cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem looking up calculated dates in another list

I have a workflow that starts another workflow when a due date is 1 business day, 3 business days, 14 days or one month before today's date. This due date is looked up from another list.

The workflow works when I calculate the due date in the workflow using the Calculate date action (i.e. due date from list less 1 day).

The problem doing it this way is that I only want it calculate the due date less 1 day using business days. As a work-around, I have a calculated column on the list where I am getting the due date from with this formula:

=IF(WEEKDAY([Due Date])=1,([Due Date]-2),IF(WEEKDAY([Due Date])=2,([Due Date]-3),([Due Date]-1)))

I can look up this date no problem - but it doesn't fire the workflow as expected.

Does any know if there is a problem looking up calculated dates from a list? If there is, is there a work-around that anyone knows of?

When I log to the history list the date being pulled from the list and the date being calculated in the workflow, they are the same. I don't know why one works and the other doesn't.

Thanks!

Labels: (1)
0 Kudos
Reply
2 Replies
andrewg
Nintex Newbie

Re: Problem looking up calculated dates in another list

Could it be that the value you are querying isn't actually the data type of Date?

0 Kudos
Reply
emha
Nintex Newbie

Re: Problem looking up calculated dates in another list

similar problem has been raised here and resolved with comparing dates in ISO format

modified dates not properly evaluated in a condition

0 Kudos
Reply