topic Re: Convert a five digit date to MM/DD/YYYY in the data load in App Development

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

jerryr125 — Tue, 06 Apr 2021 14:25:57 GMT

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

Nicole-Smith — Tue, 06 Apr 2021 14:58:00 GMT

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 — Wed, 07 Apr 2021 01:30:49 GMT

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

Nicole-Smith — Thu, 08 Apr 2021 17:23:35 GMT

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