Hi All,
I am trying to figure out if a particular task has an upcming due date by seeing if a particular date field falls within 4 weeks from today.
I have written the following formula:
IF(AND({Milestone_Current_Due_Date} <= DATEADD(TODAY(), 1, ‘month’)),{Milestone Status}!=‘Completed’, “Upcoming Due Date”)
But as you can tell from this screenshot it does not seem to operating correctly, saying some tasks have an upcming due date that is not within 4 weeks.