Converting ISO date to European format date with leading zeros

[JaponaisNaturel]

Hi everyone,

An application is sending me a date in ISO format (2022-02-13) and I want to convert it in the european date format without dropping the day and month leading zeros ( = 13/02/2022). I managed to convert from ISO to European but the leading zeros are dropped.

If I use the DATETIME_FORMAT with the 'L' specifier, the leading zeros are back but the format reverse to the american format ( = MM/DD/YYYY).

Is there a way to keep both the european format and the leading month and day zeros ?

Thanks in advance for your help,

Gilles

[TheTimeSavingCo · Accepted solution]

Hm, may I know what issues you faced using DATETIME_FORMAT with 'DD/MM/YYYY'?

DATETIME_FORMAT(
  Date,
  'DD/MM/YYYY'
)

Apologies if I've misunderstood something

[JaponaisNaturel]

Thanks for your reply Adam !  You did not misunderstood anything !

What you proposed worked perfectly !

I don't know what I did wrong when I tried DATETIME_FORMAT yesterday but that wasn't what I got at the time.

Anyway, thanks again for your help !

Problem solved !