Formula that shows "Yes" if date is in the previous year

Question

Hello everyone,

I have currently the following formula in my table that shows "Yes" if the date in "Fin contrat" is in a future month. I am trying, but with no success, to adapt this formula to show "Yes" in another column if the same date is in the previous year (so currently 2022).

Can someone please help me achieve this?

Thanks! 🙂

IF(
 IS_AFTER(
    {Fin contrat},
    DATEADD(
      DATEADD(
        DATETIME_PARSE(
           "01 " & DATETIME_FORMAT(
             TODAY(),
             "MM YYYY"
           ),
           "DD MM YYYY"
        ),
        "1",
        "months"
     ),
     "-1",
     "days"
  )
),
"Yes",
"No"
)

Stephen_Orr1 · Accepted Answer

Hi @ClarenceK,You could adapt this formula to something like: IF(   IS_BEFORE(     {Fin contrat},      DATETIME_PARSE('1/1/' & YEAR(NOW()))   ),   'Yes',   'No') *but this would be 'yes' for all previous years, not just last year.If you want to check if a date's year = last year, you could do: IF(   YEAR({Fin contrat}) = YEAR(DATEADD(NOW(),-1, 'year')),   'Yes',   'No') Hope that helps!-Stephen

ClarenceK · Answer

Hi @ClarenceK,You could adapt this formula to something like: IF(   IS_BEFORE(     {Fin contrat},      DATETIME_PARSE('1/1/' & YEAR(NOW()))   ),   'Yes',   'No') *but this would be 'yes' for all previous years, not just last year.If you want to check if a date's year = last year, you could do: IF(   YEAR({Fin contrat}) = YEAR(DATEADD(NOW(),-1, 'year')),   'Yes',   'No') Hope that helps!-StephenThat's perfect, thank you very much @Stephen_Orr1!

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded