MID,LEFT,RIGHT functions in Alteryx | Regx

[Sarath27]

Hi All,

StartDate - 20211223

I want this to be transformed into a date as "23/12/2021".

Pls suggest me the formula or regex to bring this.

Thanks.

[JosephSerpis]

Hi @Sarath27 you would need to use a combination of datetime parse and dateformat formulas to achieve your results.

[DataNath]

Hey @Sarath27, you can use the following in a Formula tool:

DateTimeFormat(DateTimeParse([StartDate], '%Y%m%d'),'%d/%m/%Y')

[Deano478]

@Sarath27 to add to @DataNath  and @JosephSerpis solutions if you use this format the value will need to be stored as a String