= #Date# problem

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

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

Any ideas?

Thanks

--
Darren

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200809/1

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 wrote:
Putting together a simple query and noticing some abnormal behaviour e.g.

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

Any ideas?

Thanks

Hi John

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

Thanks

John Spencer wrote:
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

--
Darren

Message posted via http://www.accessmonster.com