View Single Post
  #3 (permalink)  
Old August 14th, 2006, 10:15 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

If you're talking about filtering the date fields via VBA programming just remember to delimit the date variable with pound signs. For example:

Me.Filter = "[dtmDueDate] < #" & Date() & "#"

Also remember not to name any fields in your tables just DATE because that is a reserved Access function that returns today's date.

The function Now() returns the date and current time, so only use that one if time of day matters. If not, comparing a date to Now will rarely match because a date is usually stored with midnight as the time if Now was not used in the first place.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote