Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Creator III
Creator III

Convert a five digit date to MM/DD/YYYY in the data load

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

2 Solutions

Accepted Solutions
Nicole-Smith

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 FieldName
FROM YourSource;

View solution in original post

Nicole-Smith

Great!  I'm glad to hear the simple solution worked otherwise it would have taken much more digging.

View solution in original post

3 Replies
Nicole-Smith

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 FieldName
FROM YourSource;

jerryr125
Creator III
Creator III
Author

Thanks - I got it work - dates can be tricky at times - trial and error - jerry

Nicole-Smith

Great!  I'm glad to hear the simple solution worked otherwise it would have taken much more digging.