topic Re: DATE format changed when qvd is read in Qlik Cloud in App Development

DATE format changed when qvd is read in Qlik Cloud

AnaSilva — Tue, 17 Sep 2024 18:46:33 GMT

Good day,

One of our clients has migrated from Qlik Sense Enterprise (QSE) to Qlik Cloud (QCS). They pull all dates from a QVD called DIVISION_CALENDAR.qvd.

In QSE, the date format is YYYY-MM-DD.

However, the same qvd read in QCS displays the format MM/DD/YYYY.

Client wants the same format from QSE to be in QCS. What are we not seeing? How can we fix the format in QCS?

Any help is greatly appreciated.

Re: DATE format changed when qvd is read in Qlik Cloud

marksouzacosta — Tue, 17 Sep 2024 18:54:58 GMT

Hi @AnaSilva,

It can be related to the DateFormat and TimestampFormat variable in the Main Section.
Try this change:

SET DateFormat = 'YYYY-MM-DD';
SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff] TT';

Re: DATE format changed when qvd is read in Qlik Cloud

Vegar — Tue, 17 Sep 2024 19:17:05 GMT

For changing it on app level please have a look here:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Apps/regional-settings-in-apps.htm

If you want to change your default then enter your user profile settings and change your regional settings for creating apps and scripts. See image below and this link