Posted by Ross Presser on 07/22/05 17:04

On 22 Jul 2005 06:15:53 -0700, Stu wrote:

> WHERE (dbo.Membre.Date_MAJ > GETDATE() - 1) AND
> (dbo.Membre.Date_MAJ <
> GETDATE() + 1)
>
> is looking for dates that fall between NOW (in Access terms) and NOW
> minus 1 day.

actually, it's looking for dates that fall between NOW -1 and NOW + 1 day.
As I write this, therefore, it would match anything between 7/21 10:04 AM
EDT and 7/23 10:04 AM EDT.

• Next in forum: Re: WHAT DO I USE TO MAKE A TODAY DATE QUERY?
• Prev in forum: Update queries using more than one table
• Thread view: Re: WHAT DO I USE TO MAKE A TODAY DATE QUERY?

[Reply to this message]