Help

Converting ISO date to European format date with leading zeros

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
1754 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JaponaisNaturel
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-02-08 at 5.27.55 PM.png

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

Apologies if I've misunderstood something

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-02-08 at 5.27.55 PM.png

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

Apologies if I've misunderstood something

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 !