date format

  • Thread starter Thread starter bijan
  • Start date Start date
B

bijan

Hi all
when I get data from database(SQL queries) it shows date format like 38306
instead of 2004/11/15, how can I converted this date format automatically
during executing queries?
Thanks
 
Hi

Format the column as Date, then all dates should appear correct.

Regards,
Per
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date formatting in VBA 1
Need help in converting text string based date to excel date format 2
International Date formatting 4
Access Determine what query to run based on a checkbox 0
Date match problem 2
Passing dates to Sql Server 2005 stored procedure 1
Find Date in different format 1
Excel How to change the "Short Date" format in Excel? 4

Back
Top