Date Time Difference AND

Here is the formula I’m currently working with:

AND(
IF(
DATETIME_DIFF(TODAY(),{Date Status was Modified},‘days’) > 30), IF({Status} = “Open”)), “No”

I’m trying to say if the {status} field contains “Closed” AND if the {Date Status was Modified} is more than 30 days ago, then populate the formula field with “No”. I think I’m close, but I can’t get it to work. Any help would be greatly appreciated.

Thanks!

Here you go:

IF(
AND(
DATETIME_DIFF(TODAY(),{Date Status was Modified},'days') > 30,
{Status} = "Open"
),
"No")
1 Like

Thanks @ScottWorld. That worked perfectly. I appreciate the quick response!

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.