topic Re: Wrong date format is coming while exporting qliksense report into excel data in App Development

Wrong date format is coming while exporting qliksense report into excel data

Neha — Mon, 20 Dec 2021 21:38:40 GMT

Wrong date format is coming while exporting qliksense report into excel data.

I did notice a strange action with the dates.

The dates appear correct on the Qlik report. However, if I export the data to Excel, the date actually changes (e.g. 12/17/2019 vs. 1/17/19 12:12 AM). Kindly help. Thanks.

Re: Wrong date format is coming while exporting qliksense report into excel data

TimvB — Mon, 10 Feb 2020 19:33:55 GMT

In Qlik Sense your Date field contains a timestamp (e.g. 1/17/19 12:12 AM). In a chart object, you defined the Date dimension as “Date”, so the chart object hides the time and only shows the date (e.g. 1/17/19). When exporting to Excel, all data will be exported including the hidden parts. So, Qlik exports the full timestamp. The same holds for example for decimal values. If you define decimal values as an integer format in an object and export it, Qlik will export the full decimal values.

If you only want the date to be exported, you should use the Floor() function to drop the timestamp. So, in an object, use the following dimension expression: Date(Floor(DateField),'MM/DD/YYYY').

Hope it helps!

Re: Wrong date format is coming while exporting qliksense report into excel data

Neha — Thu, 13 Feb 2020 11:00:49 GMT

Hello Tim,

Thanks alot for the solution. It helped me.

Regards,

Neha