Or use your original default format and interpret all your input fields containing dates using Date#(FIELD,'YYYYMMDD')
If your date field values were interpreted correctly as dates, then you can format your values using Date() function (e.g. in the master calendar code section).
Qlik Sence stores each date, time and time stamp found in data as a datetime Serial number.
The date time for 01/01/2014 06:00:00 is represented as 41640.25 where:
- The integer part, 41640, represents the date and is the number of days elapsed since Dec.30, 1899.
- The decimal part represents the time stored as a value between 0 and 1. This nummber is the faction of elapsed time from a full day. Therefor, 06:00:00 is six hours elapsed from a full day, or 0,25. The value 0.0 corresponds to 00:00:00, 0.99999 coresponds to 23:59:59.
Text displayed: 4/26/2012
When you load data into Qlik Sence, fields containing numbers with a defined data type in a database are handled according to their respective formats.
You can use to define input and Output Formats of Dates:
- Data(), Time() --> Formating functions define the Format for how to present the data in Qlik Sence
- Data#(), Time#() --> Number Interpretation function that define the data Format of the date being loaded into Qlik Sence.