Date Format file merge

[EmilAlteryx01]

The Date column on one input file for the workflow is in a mm/dd/yyyy while on the other yyyy-mm-dd

So now my Date column reads as ,

Date

08/23/2022

08/02/2022

2022-08-23

How do i get all the rows to read in 2022-08-23 format 

[MilindG]

I'm sure there is a way better way to do this but I converted from string to date and combined the data.

[DataNath]

If these are the only two formats in the field then you could just use a Formula tool with the following expression:

if !isnull(DateTimeParse([Date],'%m/%d/%Y')) then DateTimeParse([Date],'%m/%d/%Y') else [Date] endif

[binuacs · Accepted solution]

@EmilAlteryx01 Another way of doing this by using the Contains function

[EmilAlteryx01]

Thank you All - This worked