Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Converting ISO date to European format date with leading zeros

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
1986 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 !