cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
tricias
Nintex Newbie

Update Status column based on date range (custom list)

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

Reply
2 Replies
Automation Master
Automation Master

Re: Update Status column based on date range (custom list)

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

something like this should work?

0 Kudos
Reply
eiben
Nintex Newbie

Re: Update Status column based on date range (custom list)

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:

Reply