Having trouble with an IS_BEFORE and IF formula!

[alinaaks]

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 🙂

[TheTimeSavingCo · Accepted solution]

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

[alinaaks]

Thanks so much! Makes perfect sense!