Date format not retained after downloading in Excel

Ankhi — Wed, 19 May 2021 15:35:50 GMT

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

Re: Date format not retained after downloading in Excel

scnelson99 — Thu, 15 Jul 2021 16:15:00 GMT

looking for answer to this as well

topic Date format not retained after downloading in Excel in App Development

Date format not retained after downloading in Excel

Re: Date format not retained after downloading in Excel