Parse a date while keeping the European date format

[James_Samuel]

I’m struggling with dates, and suspect it might have to do with the different conventions for describing dates. Here in NZ (and in most of Europe) we use DD-MM-YYYY whereas in the US you use MM-DD-YYYY.

Rather than describe in words, it will be easier to show you these screenshots that tell the story.

I’m trying to present a date (that is recognised as a date), that is stripped of the time details in the DateTimeStart field.

[Tuur]

Yup.

DATETIME_FORMAT(SET_TIMEZONE(NOW(), ‘Europe/Amsterdam’), ‘YYYY-MM-DD HH:mm’)

Works.

Cheers @Alexander_Sorokin