Dateadd Problem

[jamespeters01]

Is there a complete opposite to the Dateadd function??

I want my query to show the last 13 weeks activity as of the date specified by the user.


Any help would be appreciated

Cheers

 

[dalchri]

Just make the number you add to the date negative. For example:
[tt]
DateAdd('d',-13,YourDateParameter)
[/tt]

 

[jamespeters01]

Thanks.

To enable it to show every return for my criteria, I used this formula.... Between Now() And DateAdd("ww",-2,[Enter Todays Date])

This work fine, but I would now like to group the two weeks worth of returns into just 2 figures...i.e Wk1 & Wk2

Any further ideas ?


Cheers

 

[dalchri]

I would add a new, calculated field to the query and group on it. For example, Format(YourDateField,"ww&quot will give you the week number for the week. When you group the summary on this field, you will get a summary by week.