Skip to main content

Hi Airtable Community!

I'm not sure what I'm doing wrong with this formula. We are changing our pay rates on April 1st and I want to program my payment field to reflect this change. My table has a date field called "Fecha !!!" and a lookup field for our new rates and our old rates.

If the record has a date before April 1st I want it to use the old rates. If it has a date on or after April 1st I want it to use the new rates. Here's what I have so far! I'm a beginner! Thanks for your patience and  advice 🙂

You don't need the "=TRUE()" bit, and you need to format that April 1st as a date with DATETIME_PARSE(), so you'd end up with something like:

 

IF(
IS_BEFORE(
{Fecha !!!},
DATETIME_PARSE("01 04 2023", "DD MM YYYY")
),
{Old Rate},
{New Rate}
)

 

Thanks so much! Makes perfect sense!

Reply


Terms & Conditions