DatePart Month always on 2 digit

e_montaine
Level 1
DatePart Month always on 2 digit

Hi,

Using a formula recipe having :

datePart("2020-01-15T00:00:00.000Z","months")

I always get 1 for january, 2 for february, ...

I would like to get the result on 2 digits systematically to have 01 for january, 02 for february ...

Would you have any idea using other method ? 

Many thanks in advance.

0 Kudos
1 Reply
e_montaine
Level 1
Author

In fact, a simple substring("2020-01-15T00:00:00.000Z",5,7) works perfectly !

0 Kudos