Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goodmorning,
I have some problems converting numeric fields that contains dates (For example : 20090130) within the Loading script. I want to convert this to a valid date field, like 'YYYY-MM-DD'.
Any suggestions how to solve this easily?
You can try date('FieldName','YYYY-MM-DD') as FieldName
or date(date#('FieldName','YYYYMMDD'),'YYYY-MM-DD') will work if the first part does not.
Kind Regards,
Footsie
Hi,
you can try:
date(date#([YOUR_DATE], 'YYYYMMDD'), 'YYYY-MM-DD')
Regards.
€: Too slow
Thanks, this worked!!
Best regards.