exporting from qlikview to excel the date format to be mmm-yy

[#1]

Hi,

When I export data to excel the date format is not kept the same as in the Qlikview model. I have my SET DateFormat='MMM-YY';, but when it exports to excel it exports as "dd-mmm" format.

However, if I export for a few months which is less data it exports fine, but once i export for more months which is more data (more records), it exports as "dd-mmm" format !

Anyway around this to be exported in the same format as the model which is "MMM-YY"??

Regards, Jivesh

[#2]

Hi Jonathan

Thanks for your feedback,

When i export to text i have the same issue, date format is in "dd-mmm"? it doesn't keep the same date format as in the model which is "mmm-dd"

[#3]

Hi Hirish

The month list box goes blank when I use  your recommended scrip of  Date(Date#(Month,'MMM-YY'),'MMM-YY') as Month