Convert numeric fields to date

[#1]

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?

[#2]

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

[#3]

Hi,

you can try:

date(date#([YOUR_DATE], 'YYYYMMDD'), 'YYYY-MM-DD')

Regards.

€: Too slow

[#4]

Thanks, this worked!!

Best regards.