Query on date

[McFestoe]

I have a query that uses the following to sort records >=DateAdd("d",-21,Date())

This lists all records that have a renewal date within the next 21days, this works fine but it brings up records that are previous than todays date, is there a way to stop it bringing up the records before todays date.

 

[HarleyQuinn]

And #YourDateField# >= Date()

perhaps?

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

That's what I get for not previewing my posts, the last sentence is supposed to read:

That should do it, or you could use BETWEEN perhaps?

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[McFestoe]

Thanks, just needed a little help could not see how to do it, ended up with

>=DateAdd("d",-21,Date()) And >=Date()

Will make shure it returns what i need.

Thanks

 

[HarleyQuinn]

Looks good to me.

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

>=DateAdd("d",-21,Date()) And >=Date()
To get same resulset simply use this:
>=Date()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[HarleyQuinn]

How so PHV?

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

I see what you mean, I thought it was a strange way that the OP was doing it, from the suggestion I would think we'd want:

<=DateAdd("d",21,Date()) and >=Date()

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

all records that have a renewal date within the next 21days
In the criteria cell of [renewal date]:
Between Date() And Date()+21

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[McFestoe]

Thanks Guys for the help.

PHV just reading your last post, i cant seam to get my head around it, iam right in thinking

Between Date() And Date()+21 means

between current date and current date +21

Sorry for that i know see what you where getting at, will try that approach as well.

 

[McFestoe]

Sorry for the previous post, iam daft, thanks for showing me another way.