I have got a SQL statement to fetch last weeks web orders.
I have it scheduled it to run every Friday morning at 6 am.
I think I would need slight modification in the SQL to include date and time.
For an instance:
On 24/04/2009 I would expect all the orders between 17/04/2009 00:00 and 23/04/09 23:59
The SQL I have now seems to be returning orders between 17/04/2009 00:00 and 23/04/09 06:00
And on the following week I would get orders data between 24/04/2009 00:00 and 30/04/09 06:00
I am missing all Thursday orders done between 6 am until midnight.
Please can someone advise the change I would need in my SQL statement to include date and time.