Formula to capture LastFullWeek Last Year (1 Viewer)

[PeterOC]

I've been wracking my brain trying to solve this problem:

I've got a report where I want to show a count of jobs raised for last week but I want to compare it to the same week Last Year.

I've done a bit of searching and the nearest I can get is this:

({table.JobRaisedDate} in dateadd("yyyy",-1,minimum(LastFullWeek)) to dateadd("yyyy",-1,maximum(LastFullWeek)))

But this doesn't work because it's taking the start of the last full week this year and just subtracting a year.

Any help would be mucho appreciated.

P

 

[amerr01]

({table.JobRaisedDate} in dateadd("yyyy",-1,minimum(LastFullWeek)-1) to dateadd("yyyy",-1,maximum(LastFullWeek)-1)) worked for me... you were almost there.