topic Re: Trouble with setting the correct date time format in Qlik Automate

Trouble with setting the correct date time format

StanFV — Fri, 14 Jun 2024 10:24:19 GMT

We are building a calendar in Qliksense. Our date time data is structured as 45019. We want it to show up in our dashboard as April 3, 2023 or 4/3/2023. What script do we need in the back end to do this?

Re: Trouble with setting the correct date time format

Lech_Miszkiewicz — Fri, 14 Jun 2024 10:36:42 GMT

Hi,

1. When loading data make sure you setup in your MAIN section of load editior script variables to required format.

2. Then you cal load your field with the respected format like

- Date(your_date, 'M/D/YYYY') as SalesordersOrderdatum

Note that you want to use name of the field which was not previously used in your load script as fields with masks (like dates) retain the original format (the format which was used to load field first time in your data model)

cheers

Re: Trouble with setting the correct date time format

StanFV — Fri, 14 Jun 2024 10:51:40 GMT

Thank you very much!!

Cheers indeed 🙂