Excluding Timeframe in equation

[Thompyt]

Here is what I am using:


IIf(DateDiff("ww",[Date_ID],[Date_Closed])>1,(DateDiff("ww",[Date_ID],[Date_Closed]))-1,0)

This works great if there are no exceptions. As usual we have discovered an exception. What if I wanted to exclude a weeks time? I would gather if you have 2 different weeks time you would put an And in it. For now I need to exclude a week from this.

21 May 2015 to 27 May 2015.

Thanks

[ranman256]

the new END date would be:

dateadd("d",-7,[Date_Closed])

[Thompyt]

That would work for an overall, but I need it to affect only those actions that were in that time frame.

[June7]

Don't understand. If you need to exclude records then apply filter criteria to the dataset.