Date Conversion

[mkc80]

Hi,

I am trying to convert a date in the text format to Date format using the CDate() function in a sql query in MS Access, which is working fine. But when I try to export the results to a an excel file, the date is being displayed as text field again.

How do I correctly convert & format the text values and then export the values as Date (Numeric) in to Excel?

And the date is in the UK format 'dd/mm/yyyy'



Please advise.

[June7]

Show your SQL Statement.

I tested export with the wizard and the date column in Excel was given Custom format of dd-mmm-yy.
SELECT [103].LabNum, CDate("1/1/2012") AS TestDate FROM 103;