Convert Date Format

[Alaska93]

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

[marcus_sommer · Accepted solution]

You could use alt() for multiple converting like:

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

- Marcus