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
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