Date in one format

[ag72]

Hello, 

In my data in excel i have dates in 2 formats - due to which Alteryx is getting confused for dates - so what's the best way to make this in one single Alteryx readable format?

Alteryx is calculating wrong days for this format  - "02/01/2022 17:00"

Date

02/01/2022 17:00

02/02/2022 17:00

02/03/2022 17:00

02/04/2022 17:00

02/07/2022 17:00

02/08/2022 17:00

02/09/2022 17:00

02/10/2022 17:00

02/11/2022 17:00

2/14/2022 5:00:00 PM

2/15/2022 5:00:00 PM

2/16/2022 5:00:00 PM

2/17/2022 5:00:00 PM

2/18/2022 5:00:00 PM

2/21/2022 5:00:00 PM

2/22/2022 5:00:00 PM

2/23/2022 5:00:00 PM

2/24/2022 5:00:00 PM

2/25/2022 5:00:00 PM

2/28/2022 5:00:00 PM

03/01/2022 17:00

03/02/2022 17:00

03/03/2022 17:00

03/04/2022 17:00

03/07/2022 17:00

03/08/2022 17:00

[binuacs · Accepted solution]

@ag72  use the DateTimeParse() function to convert into alteryx date format

DateTimeParse([Date],’%m/%d/%Y’) and select data type as Date