Leading zero with Month() function

How do I get a trailing zero when in a calculation field I would take
Month(Date1)
When Date1=Currentdate

In the end I need a identifcation field consisting of a Year{2 digits}+Month(Currentdate){2 digits}+autonumber{3 digits} in total 7 digits

Peter,

Do you mean a leading zero? Here’s a way to do that. I created a field named “Today” that has today’s date. Then I created an equation that adds 100 to the date and then takes the last two digits.

Here is the result:
image

Best regards,
Henry

2 Likes