Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Professor-Ambassador
Professor-Ambassador

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;

View solution in original post

jerryr125
Professor-Ambassador
Professor-Ambassador
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.

View solution in original post