Converting Multiple Date format to one format

[dunkindonut7777]

I how to convert these dates in one column using formula tool.

Date	Expected Output
2023-02-25 00:00:00	2023-02-25
6/21/2023	2023-06-21

Can you help me with this one pls.

[binu_acs]

@dunkindonut7777 One way of doing this

IIF(Contains([Date], "-"), DateTimeParse([Date],"%Y-%m-%d"), IIF(Contains([Date], "/"), DateTimePArse([Date],"%m/%d/%Y"), Null()))

[ShankerV]

Hi @dunkindonut7777 

Please use the below formula.

IF REGEX_Match(Left([Date],4),"\d{4}")
THEN DateTimeParse([Date],"%y-%m-%d")
ELSE DateTimeParse([Date],"%m/%d/%y")
ENDIF

Many thanks

Shanker V