Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 04:51 PM
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 🙂
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2023 12:19 AM
Yeap:
IF(
IS_AFTER(
Date,
DATEADD(
DATEADD(
DATETIME_PARSE(
"01 " & DATETIME_FORMAT(
TODAY(),
"MM YYYY"
),
"DD MM YYYY"
),
"-6",
"months"
),
"-1",
"days"
)
),
"Yes",
"No"
)
 
Reply
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2023 12:19 AM
Yeap:
IF(
IS_AFTER(
Date,
DATEADD(
DATEADD(
DATETIME_PARSE(
"01 " & DATETIME_FORMAT(
TODAY(),
"MM YYYY"
),
"DD MM YYYY"
),
"-6",
"months"
),
"-1",
"days"
)
),
"Yes",
"No"
)
 
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2023 01:58 AM
That's awesome. Thank you so much!
