Skip to main content

Date Time Difference AND

  • March 9, 2021
  • 2 replies
  • 17 views
B

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!

2 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • March 9, 2021

Here you go:

IF(
AND(
DATETIME_DIFF(TODAY(),{Date Status was Modified},'days') > 30,
{Status} = "Open"
),
"No")
Ken_Szczepanski
B
  • Brett_Smith1
  • Author
  • New Participant
  • March 9, 2021

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

ScottWorld
Terms & ConditionsAccessibility statement