Issue in Date Format while exporting to excel

vijay_sr

Hi,

I am designing a BIRT report (V2.3.2) , there is a table with column header as "Data" of data type "date", which is dynamically computed. The date format is set as "dd-MMM-yy EE". It computes fine and shows the date in the correct format "09-jul-10 Fri" in the report. But when i "Export to Excel", it exports with value "09-jul-10" and not the day (Fri - in this case). The excel Version is 2003.
Can you please let me know if i am missing any thing format or is it a know defect in BIRT ?


Thanks & Regards
Vijay

mwilliams

Hi Vijay,

It doesn't look like this format is supported in Excel. If you were to put the format "dd-MMM-yy ddd" and then exported to Excel, it would work as expected, but you'd have a weird format within other output formats in BIRT. You could possibly set the custom format depending on the output format, so that in XLS output, you'd use ddd and for others you'd use EE.

Hope this helps.