+3Hello 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 🙂
Best answer by TheTimeSavingCo
Yeap:
IF(
IS_AFTER(
Date,
DATEADD(
DATEADD(
DATETIME_PARSE(
"01 " & DATETIME_FORMAT(
TODAY(),
"MM YYYY"
),
"DD MM YYYY"
),
"-6",
"months"
),
"-1",
"days"
)
),
"Yes",
"No"
)
+31Yeap:
IF(
IS_AFTER(
Date,
DATEADD(
DATEADD(
DATETIME_PARSE(
"01 " & DATETIME_FORMAT(
TODAY(),
"MM YYYY"
),
"DD MM YYYY"
),
"-6",
"months"
),
"-1",
"days"
)
),
"Yes",
"No"
)
+3Yeap:
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.