topic Date not formatting correctly when exporting to Excel in QlikView

Date not formatting correctly when exporting to Excel

denwo2010 — Tue, 09 Aug 2011 11:46:03 GMT

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

Re: Date not formatting correctly when exporting to Excel

its_anandrjs — Tue, 09 Aug 2011 12:42:12 GMT

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

Date not formatting correctly when exporting to Excel

denwo2010 — Tue, 09 Aug 2011 13:06:14 GMT

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.

Date not formatting correctly when exporting to Excel

Tue, 09 Aug 2011 14:50:16 GMT

Hi,

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

Best regards,

Bert

Date not formatting correctly when exporting to Excel

denwo2010 — Tue, 09 Aug 2011 14:57:45 GMT

Using the excel button on the table

Date not formatting correctly when exporting to Excel

its_anandrjs — Tue, 09 Aug 2011 15:05:28 GMT

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