European date formats default option

Hi @Jonathan_Richardson,

I understand your frustration (I really do).

In the meantime there are some workarounds (quite easy) that are useful especially in importing/exporting data with excel/Google sheet.

You can create an export view that - instead of the actual date column - it displays an explicitly text-converted column that contains what the destination would expect.

If for example the date format of the destination is European ("DD/MM/YYYY"), you can create a European Date column (with Text datatype) with the following formula:
Format("{2:00}/{1:00}/{3}", thisRow.[Your Date].Split("/")

Hopefully a more radical Date/Time handling will sort it once for all, but it’s a quick patch that does its job.

I hope it helps.
Cheers

5 Likes