I need to automate a query to produce results from a date range and can't get my head around the format of the criteria needed.
The query must select records from the PREVIOUS Thursday to LAST Friday. IE, today is Thursday 31st March, so today my query should return all results from Thursday 17th March through till Friday 25th March.
If it was Monday 21st March today, it should report on 10th to 18th March
How on earth can I do this?