String conversion

[Sarath27]

Hi All,

How to convert the below string?

15082023  (ddmmyyyy) to 15_08_2023(dd_mm_yyyy)

Thanks in Advance.

[geraldo · Accepted solution]

@Sarath27 

the formula: If the format ddmmyyyy is numeric change it to string

DateTimeFormat(DateTimeParse([Date],'%d%m%Y'),'%d_%m_%Y')

[Sarath27]

Thanks much.

[KamenRider · Accepted solution]

Hi @Sarath27 

Please see below my solution:

 

regards,

Kamen