Hi Everyone,
I am attempting to create a recurring batch job to End production orders. In the query form I simply want to specify to end any production orders that have a "Reported as finished" date of the current date minus 2 days. Based on this requirement I have set it up like the below image.
The problem here is that if today is 9/17/2014, and I have the first run of the batch job schedule for tonight, it will run successfully and end the production orders for 9/15/2014. However, when it runs again tomorrow on 9/18/2014, it will once again try to end the production orders from 9/15/2014 when I am wanting it to end the production orders for 9/16/2014.
It feels as if the query does not keep refreshing the (Day(-2)) parameter. Any thoughts?
Thanks,
Jim