AnsweredAssumed Answered

Update Status column based on date range (custom list)

Question asked by tricias on Jul 24, 2017
Latest reply on Jul 24, 2017 by Henning Eiben

Hi

I have created 5 date columns:

Today (updated by a workflow with todays date)

Today+30

Today+365

Today-1000

Calibration Due (autofills based on the date in the Calibration Certificate)

 

I also have a status column with three choices:

No Action Required

Action Required

Action Overdue

 

What I want to do is:

When the "calibration due" date is between (Today+30) and (Today+364), the status is "no action required".

When the "calibration due" date is between (Today) and (Today+30), the status is "Action required"

When the "calibration due" date is between (Today) and (Today-1000), the status is "Action overdue"

 

But I can't seem to find an appropriate action!  I've set the date variables (today, today+30, etc.)  Can someone give me a bump start?!?

Outcomes