Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 18, 2022 03:16 AM
Hello everybody,
I have been using a formula to generate invoice numbers, but is has been producing some overly similar looking numbers which confuses clients.
Current formula is:
“INV” & DATETIME_FORMAT(CREATED_TIME(),‘msw’)
What I’d like to change it to is:
“INV” & DATETIME_FORMAT(CREATED_TIME(),‘wms’)
The only problem is that if I change it now, all of my previously issued invoice numbers change too.
Is there a way to perform the below?
If date is on or before 18.04.2022 then
“INV” & DATETIME_FORMAT(CREATED_TIME(),‘msw’)
else
“INV” & DATETIME_FORMAT(CREATED_TIME(),‘wms’)
Your advice would be very helpful! Thank you.
Apr 18, 2022 02:20 PM
Hi @C-B_2021
Can you try this:
IF(CREATED_TIME()<=04/18/2022,"INV" & DATETIME_FORMAT(CREATED_TIME(),'msw'),"INV" & DATETIME_FORMAT(CREATED_TIME(),'wms'))
Apr 19, 2022 01:30 AM
Hi, Vivid_Squid. Thank you so much for helping out!
I have input your code and there are no errors, although it appears to skip the If Date < statement, and proceeds to implement ‘wms’ for all date ranges.
Any ideas? Thanks again.
May 03, 2022 01:28 AM
Sorry @Vivid-Squid, I forgot to tag you!
If you have time, please seem my response above. All the best.
May 03, 2022 03:33 AM