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])
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!