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 🙂
Solved
Having trouble with an IS_BEFORE and IF formula!
+3Best answer by TheTimeSavingCo
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}
)
+31You 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}
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.