topic Re: Change non uniform dates to uniform in App Development

Change non uniform dates to uniform

New-here1 — Fri, 19 Jan 2024 10:22:57 GMT

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 — Fri, 19 Jan 2024 10:34:15 GMT

Hi,

Try this :

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

Regards,

Rohan.

New-here1 — Fri, 19 Jan 2024 10:42:58 GMT

That worked, thank you @Rohan