Convert Date Format

Alaska93 — Wed, 02 Feb 2022 08:35:58 GMT

Hello community,

I have the 'DateCom' field in my dataset which is in text format. I want to convert it to date format ('DD/MM/YYYY').

However, the 'DateCom' field contains 4 different entries:

- DD/MM/YYYY

- DD/MM/YYYY hh:mm

- YYYY/MM/DD

- YYYY/MM/DD hh:mm

I used Date(Date#(.....)) but it only gives me rows for which I specified the format.

What can I do to solve this problem?

Thank you for your help

Re: Convert Date Format

marcus_sommer — Wed, 02 Feb 2022 15:02:45 GMT

You could use alt() for multiple converting like:

date(alt(date#(Field, 'Format1'), floor(timestamp#(Field, 'Format2')), ...)

- Marcus