<= #Date# problem

[Darren via AccessMonster.com]

Putting together a simple query and noticing some abnormal behaviour e.g.

<= #31/7/08# is excluding 31/7/08???

Any ideas?

Thanks

 

[John Spencer]

A guess is that the records also have a time component that you are not seeing.

Try < #2008-08-01# and see if you get the expected records.

If so, then your records have a time component as part of the date - this
often happens when someone uses the Now() function to assign a date instead of
using the Date() function.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[darren via AccessMonster.com]

Hi John

Just found this as you have replied. Indeed some records have a time
component!

Thanks

A guess is that the records also have a time component that you are not seeing.

Try < #2008-08-01# and see if you get the expected records.

If so, then your records have a time component as part of the date - this
often happens when someone uses the Now() function to assign a date instead of
using the Date() function.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Putting together a simple query and noticing some abnormal behaviour e.g.

[quoted text clipped - 3 lines]

Thanks