Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Muthu
Partner - Creator III
Partner - Creator III

Date Format Issue in While exporting to Excel

Hi,

During optimizing our application, I have separated dates into day, month year and time, In the application I have added the fields as date. While exporting the date into excel its showing as text and not in date.

Please help.

Regards,

Muthu

1 Reply
petter
Partner - Champion III
Partner - Champion III

Can you explain how you separated the dates into day, month, year and time? Did you create separate fields for each of them in a calendar table? What do you mean by adding the fields as date? Did you do a MakeDate(Year,Month,Day)?