Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi - My data contains a five digit date (example : 44340) should be 05/24/2021.
How do I convert the date in the data load ?
Thanks - Jerry
It should be as simple as wrapping your field in the date() function with the format that you want to see it in:
SELECT date(FieldName, 'MM/DD/YYYY') AS FieldNameFROM YourSource;
View solution in original post
Great! I'm glad to hear the simple solution worked otherwise it would have taken much more digging.
Thanks - I got it work - dates can be tricky at times - trial and error - jerry