Hi,
I am trying to bring up data for the last 4 weeks Friday to Friday eg Friday 1st Nov to Friday 22nd Nov.
I know that if I want to bring up results just for last Friday the formula is: Year([WeekEnding])*53+DatePart("ww",[WeekEnding])=Year(Date())*53+DatePart("ww",Date())-1 and this works.
So I have been trying:
Between Year([WeekEnding])*53+DatePart("ww",[WeekEnding])=Year(Date())*53+DatePart("ww",Date())-4 And Year([WeekEnding])*53+DatePart("ww",[WeekEnding])=Year(Date())*53+DatePart("ww",Date())-1
but this doesn't bring up any data when it should.
Any ideas what I'm doing wrong?
Any help is appreciated
FYI... Year([WeekEnding])*53+DatePart("ww",[WeekEnding])=Year(Date())*53+DatePart("ww",Date())-4 Brings up the results for 4 Fridays ago fine too