DatePart Month always on 2 digit
e_montaine
Registered Posts: 2 ✭
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.
Tagged:
Answers
-
In fact, a simple substring("2020-01-15T00:00:00.000Z",5,7) works perfectly !