Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankhi
Creator
Creator

Date format not retained after downloading in Excel

Hi ,

I have a couple of date dimensions as below in a straight table. 

Calculated Dimension: Date1

=if([X.Payment Date]>=vDateStart,if([X.Payment Date]<=vDateEnd,[X.Payment Date])) and

Date2:

date([Y.Invoice Date], 'DD/MM/YYYY').

When I download the data in excel, the dates are no longer retained as Date format. Although it looks like a date e.g.02/12/2020 but can not be sorted in the excel as it seems to be working like number.

Can you please suggest how to retain the date format after downloading in excel?

Many Thanks

Regards

Ankhi

 

1 Reply
scnelson99
Contributor II
Contributor II

looking for answer to this as well