Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula that modifies after a set date

Topic Labels: Formulas
238 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

4 Replies 4

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

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.

Sorry @Vivid-Squid, I forgot to tag you!

If you have time, please seem my response above. All the best.

@C-B_2021

To compare these 2 dates, try this:

IS_BEFORE(CREATED_TIME(),"4/18/2022")