Qlik Community

Ask a Question

App Development

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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