Date fields in access

[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?

 

[Ken Snell \(MVP\)]

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.

 

[John Spencer]

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#

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

 

[DJ Finnegan]

Thanks.....both of you big help. got it going finally.