I have created 5 date columns:
Today (updated by a workflow with todays date)
Calibration Due (autofills based on the date in the Calibration Certificate)
I also have a status column with three choices:
No Action Required
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?!?
Are those 4 columns related to "today" only used to help to determine the status or are the serving another purpose as well?
If not I would suggest a different approach. I would remove those columns and calculate the "age" of an item in the workflow, by subtracting today from the due-date. You would get the number of days until the item will be due.
Next you could update the status depending on the age of the element.
So the complete workflow could look like this:
You will need to create two variables:
At first you compute the age:
and convert the result to a number:
Next you can add conditions like this:
and finally update the status: