Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
In fact, a simple substring("2020-01-15T00:00:00.000Z",5,7) works perfectly !