When i select current weak(Monday) in parameter ,
1.i want to show current weak and last week like below,but i did this by using
IIF( [Date] >= DATEADD('week', -1,[Choose Date]) AND [Date] <= DATEADD('week', 0,[Choose Date]),true,false).Here data is not matching. "Choose Date" is parameter
You'd be better off using DateDiff('week',[Date],[Choose Date]) >=0 and DateDiff('week',[Date],[Choose Date]) <=1. Using DateAdd like you're doing will return a date one week prior to Choose Date (e.g. April 9 when Choose Date is April 16) instead of all dates for the prior week.