Excel Export Issue

[#1]

Hi All,

I have written a macro code for export trend table. The table exports successfully but the dates converts to wrong format (mm/dd to mm/dd/yyyy.

For example, when pasted on excel, 11/21 will change to 11/21/2015.

Can we stop this conversion?

Thanks

[robert_mika]

Try:

Help >> About Qlikview >> right click on the Qlik icon >>

change to String

[#3]

Hi Robert,

I changed it to String. The export is still showing incorrect dates

Thanks

[robert_mika]

Could you post your macro?

After the data are being send to Excel you can probably use sendkey function to format the data to desired output.

[#5]

hi,

when you export data that time date field took the format of your existing system date_time format.

Can you change your system(from where you exporting)date then see.

Regards

Vimlesh