IF statement with first day of 6 months ago

[ClarenceK]

Hello everyone, 

I'd like to make a formula with an IF statement that shows "OK" if a date is in the last 6 complete months. 

For example, if today is the 17th of March, it would show "OK" for every record since the 1st of September.

Is this something possible?

Thanks 🙂

[TheTimeSavingCo · Accepted solution]

Yeap:

IF(
  IS_AFTER(
    Date,
    DATEADD(
      DATEADD(
        DATETIME_PARSE(
          "01 " & DATETIME_FORMAT(
            TODAY(),
            "MM YYYY"
          ),
          "DD MM YYYY"
        ), 
        "-6",
        "months"
      ),
      "-1",
      "days"
    )
  ),
  "Yes",
  "No"
)

 

[ClarenceK]

That's awesome. Thank you so much!