Between Criteria 2

[needmoremoney]

Hello..

I'm trying to get a query to work but it's not working so well.

I have this for my date criteria.
=Now() or >Now()-14

I'm trying to pull data that are 1 to 13days old but if it is 14 days old, then I want to exclude it.

My example is still pulling for dates that are beyond the 14 days. Any help thanks much..

 

[fneily]

The criteria line should look like thisNo = sign)
>(Date()-14) And <Date()

 

[raskew]

Hi -

Copy/paste this to the criteria cell of your date field:

Between Date() And Date()-13

The Now() function includes both date and time. Better to stick with the Date() function which provides just what it says.

HTH - Bob

 

[needmoremoney]

Thanks all,

I got it to work now. I didn't know that about the Date and Now. Thanks Raskew.