Hello all,
I have a select query where I always want to retrieve the data from last week (Monday to Sunday) without inputting the date in the query.
The criteria is currently BETWEEN #04/02/2018 AND #11/02/2018. Rather than replacing a hard coded date each week I want to use an expression instead. So if I was running the query on Wed 20th Feb I want to return results for the week commencing Mon 11th Feb.
From searching on the Internet it appears that I requires a combination of date functions. I tried Between Date() - ( 6 + Weekday(Date(), 2)) AND Date() - Weekday(Date(), 2) but this is not returning the right results.
I am new to this type of query so any help would be much appreciated.
Many Thanks
Vinnie