Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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"
Hi Hirish
The month list box goes blank when I use your recommended scrip of Date(Date#(Month,'MMM-YY'),'MMM-YY') as Month