Change non uniform dates to uniform

[New-here1]

Hi All, 

I have a dataset that has 3 different date formats, for example:

- 19th & 20th January

- 19/01/2024

- Dec-2023

Is there a way to make these dates all uniform? I would like them to be DD/MM/YYYY

Thank you

[Rohan · Accepted solution]

Hi,

Try this :

Date(Alt(Date#(Field,'DD/MM/YYYY'),Date#(Field,'MMM-YYYY'),Field),'DD/MM/YYYY') as Date

Regards,

Rohan.

[New-here1]

That worked, thank you @Rohan