Please help me with this query:
I have this expression from Microsoft help :
Year([SalesDate])* 53 + DatePart("ww", [SalesDate]) = Year(Date())*53 + DatePart("ww", Date()) - 1
which Returns records of transactions that took place during the last week. A week starts on Sunday and ends on Saturday.
It works fine, I tried to modify the expression for the "last two weeks", using -2 thinking that will do the trick, it does not work. Can someone help me modifying this expression? why does not work? any suggestions?
Thank you so much
PD: My table is simple, listing events that take place in the past, field is CheckinDate, table is TblBookings
Tony30