DATE format changed when qvd is read in Qlik Cloud

[AnaSilva]

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.

[marksouzacosta · Accepted solution]

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';

[Vegar]

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-i...

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