Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF statement with first day of 6 months ago

Topic Labels: Formulas
Solved
Jump to Solution
1053 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
18 - Pluto
18 - Pluto

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
18 - Pluto
18 - Pluto

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!