Date not formatting correctly when exporting to Excel

[denwo2010]

Hi,

All of a sudden when exporting a straight table from a Document on Access Point, the dates are showing as numbers when be it would show in a date format DD/MM/YYYY, no changes have been made to any of the QVD's so not sure why this happening all of a sudden? Has anyone any idea's what could cause this?

Thanks

[its_anandrjs]

Hi,

You need to change the format of Column to date some thing like this Date(DateColumn).Please check other wise put Date(DateColumn,'DD/MM/YYYY')You alread change it then you face this problem or what, or are you able to view proper date on access or this problem accurs only when you export the excel file.

You made this changes in your load statement.

Regards,

Anand

[denwo2010]

Not sure whats happened but basically I am getting the date field from a sql server table which is a data type of "datetime", when creating the qvd for this I am putting a Left(FieldName,10) as Date.

This has been working all the time but someone today has said when they export this to excel it does not keep the format and turns this into a number field, so for the mean time the user is having to format the date via Format Cells and changing  this to a DD/MM/YYYY in excel.

[#4]

Hi,

Are you using macro's to export to excel, or the export to excel butten in a table?

Best regards,

Bert

[denwo2010]

Using the excel button on the table

[its_anandrjs · Accepted solution]

Hi denwo,

When you pull date column by Left(FieldName,10) as Date and make as a date column after that please check it is comes in correct date format or not otherwise you need to change it in Date format like by putting Date(Left(FieldName,10),'DD/MM/YYYY') as Date.

Hope this helps you.

Regards,

Anand