Converting odd looking dates to a standard format

[Deano478]

Hi Community,

This is a bit of an odd one I was sent over a file yesterday evening from a colleague and one of the fields called EntryDate contained "Dates" in a string format however they are in a very weird looking format as seen below for example 1/13/2023 there cant be 13 months in a year. 

Would anyone be able to help me convert these weird dates to the standard Altyerx format?

Any and all help is much appreciated as always.

Here a sample of the dates:

EntryDate

01/12/2023

1/13/2023 0:00

01/11/2023

01/12/2023

1/13/2023 0:00

1/16/2023 0:00

01/09/2023

01/10/2023

01/11/2023

01/12/2023

1/13/2023 0:00

01/12/2023

01/10/2023

01/11/2023

01/12/2023

1/13/2023 0:00

01/10/2023

01/12/2023

01/12/2023

01/11/2023

1/13/2023 0:00

[binuacs]

@Deano478 you can use the DateTimeParse() function to change date format

[ShankerV]

Hi @Deano478 

One way of doing this.

datetimeparse([EntryDate],"%m/%d/%y")

Many thanks

Shanker V

[Deano478]

@ShankerV  and @binuacs Much appreciated guys those weird dates are fixed for that sample but when I run it on the full dataset i get a lot of conversion errors should i attach the file itself so you guys can see it?

[Deano478]

Here is the actual file just with all the dates

[binuacs]

@Deano478 @Use the formula DateTimeparse([Date],’%m/%d/%y’)

[Deano478]

hey @binuacs I used it again on the full data set but my Results windows says this:

[binuacs · Accepted solution]

@Deano478 Just noticed that you have both formats YYYY-MM-DD and DD/MM/YYY. I updated the formula accordingly

[Deano478]

@binuacs Many thanks it worked perfectly i should have probably mentioned that in my question but thank you nonetheless