This is what happens.
I have to make three different queries
1) New Requests (per week)
2) Closed Requests (per week)
3) Pending Requests (per week)
I use the previous Fri as a Week Ending date.
What happens is if the Pending date was changed or if the request was closed(pending date gets removed)after that Fri, the number of Pending requests is wrong when I run them on Monday morning.
Since I'm not into waiting for everybody to leave on Friday night and getting my numbers then, I was hoping there was alternate solution.
New Requests - Closed Requests = Pending Requests (within a given week).
So is there a way to save the original Pending date in one field and send the updated date to another?
Any ideas are VERY welcome
Thanks
I have to make three different queries
1) New Requests (per week)
2) Closed Requests (per week)
3) Pending Requests (per week)
I use the previous Fri as a Week Ending date.
What happens is if the Pending date was changed or if the request was closed(pending date gets removed)after that Fri, the number of Pending requests is wrong when I run them on Monday morning.
Since I'm not into waiting for everybody to leave on Friday night and getting my numbers then, I was hoping there was alternate solution.
New Requests - Closed Requests = Pending Requests (within a given week).
So is there a way to save the original Pending date in one field and send the updated date to another?
Any ideas are VERY welcome
Thanks
