I have list A which has a number of date columns which are set by a list workflow using Calculate Date columns. List B is used to input the start date.
The list workflow(Red) in A Uses a Run If the status is Ready and the Record should be included (a Yes/No).
It then does a Calculate Date which in this case goes to List B and from a column called Set Date To grabs the date does it's calculation and stores the new date in a variable.
When I force the list workflow to run it works perfectly, grabs the date and places the calculated dates in the correct columns.
What I have running now is when the date is updated in List B it runs a List workflow (Blue) kicks off a site workflow (Green), which queries List A for all the records which are set to Ready and Yes. It then stores these in a collection variable. I am then running a For Each and calling a Web Service for each record collected and running the above list workflow (Red).
When the List Workflow (Red) is being started by site workflow (Green) the date variable is being set to 01/01/0001.
To validate this I inserted an email function in the list workflow (Red) just before the update and it sends me emails for all the records which meet the criteria For Each. I see the date variable has been set to 01/01/0001.
I have included the workflows in an sattachement
Any ideas?