Trouble with setting the correct date time format

[StanFV]

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?

[Lech_Miszkiewicz · Accepted solution]

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

[StanFV]

Thank you very much!!

Cheers indeed 🙂