Help

IF statement with first day of 6 months ago

Topic Labels: Formulas
Solved
Jump to Solution
459 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ClarenceK
5 - Automation Enthusiast
5 - Automation Enthusiast

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 🙂

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Yeap:

Screenshot 2023-03-17 at 3.18.47 PM.png

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

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

Yeap:

Screenshot 2023-03-17 at 3.18.47 PM.png

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

That's awesome. Thank you so much!