Hello I am trying to make an invoice number in the format TYYYY-MM-XXX where X is a random number.
The formula I am suing is CONCATENATE("T", YEAR(NOW()),"-", MONTH(NOW()), "-", RANDBETWEEN(100,999) )
I am getting T2022-2-123 as an example
The problem is month value of lets say February only returns 2 not 02 which changes my invoice length.
Is there a simple simple solution for this?
Thanks
Solved! Go to Solution.
Use the TEXT() expressions date/time formatting options, instead of YEAR() and MONTH()
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |