Update Status column based on date range (custom list)

T
Badge +3

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?!?

2 replies

C
Badge +16

Do you want to do this when the item is added or modified?

something like this should work?

E
Badge +7

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:

205881_pastedImage_1.png

You will need to create two variables:

205884_pastedImage_4.png

At first you compute the age:

205882_pastedImage_2.png

and convert the result to a number:

205883_pastedImage_3.png

Next you can add conditions like this:

205886_pastedImage_5.png

and finally update the status:

205887_pastedImage_6.png

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings