Date fields in access

  • Thread starter Thread starter DJ Finnegan
  • Start date Start date
D

DJ Finnegan

I've added a date stamp in table for new records, I've updated old records
with date however, I don't seem to be able to search through query and pull
in records based on this field. Am I missing something?
 
How are you writing the query? The # character is the delimiter for date
values when you type in a "date string":
#11/26/2008#

It's possible that your query is not seeing your parameter dates as date
values.
 
Is your date stamp a datetime field?
Are you storing the date and the time in the field?

If your fields have a date and a time then you will need to search a date
range. For instance the following witll get all records for Jan 30 2008 and
any records that have a time of midnight on Jan 31, 2008.

Between #2008-01-30# and #2008-01-31#

This criteria will only get records on Jan 30 2008.
=#2008-01-30# and < #2008-01-31#
Click to expand...


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