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

Using date to create Invoice numbers

Marc_Dillon February 16, 2022, 7:58pm 2

Use the TEXT() expressions date/time formatting options, instead of YEAR() and MONTH()

3 Likes

Topic		Replies	Views
Double digit for month and date AppSheet Q&A databases , expressions	2	2	November 28, 2021
Autogenerate Invoice Number based on Year, Month and Invoice Status AppSheet Q&A expressions	1	4	March 28, 2021
Hello, how do I format the dates? In Sweden w... AppSheet Q&A	3	0	April 18, 2018