Text to Date

CM246

Hi,

I have a date in text format YYYYMMDD which I want to convert to a date format as DD-MM-YYYY. I have tried splitting out the year, month and day to then join them back in the correct sequence and also used a Datetimeparse tool but it is giving back blanks. 

Can some please help to understand how to over come this?

Thanks in advance.

afv2688

Hello @CM246 ,

I am sorry to tell you that dates are only displayed in Alteryx in ISO format (YYYY-MM-DD).

I would recommend you to do all the transformations you need to then in the en give them the format you like. Once you change the format, the dates will become strings.

To change them you could use for example:

DateTimeFormat([DateField],'%d-%m-%y')

Again, this will no longer be a date field, this will be a string field.

Regards