Month() return two digits instead of one?

I’m using the Month() thing in a formula and I’d like it to return two digits (01 for January) instead of just one (1 for January). Is this possible?

Formula is something like this:

=Month([Date Field])

Hi @Kelly_Claus

you might want to use LeftPad() formula:

Today().Month().LeftPad(2,0)

Alternatively, the padding pattern in Format()

Format("{1:00}", Today().Month())

I hope this helps.
Cheers!

4 Likes

Amazing thank you @Federico_Stefanato !

1 Like