Converting Multiple Date format to one format

Question

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

DateExpected Output2023-02-25 00:00:002023-02-256/21/20232023-06-21

Can you help me with this one pls.

ShankerV · Answer

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

binu_acs · Answer

@dunkindonut7777 One way of doing this

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