Date Time query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a date field with no format. The users have now keyed in long and
short date values. When I query for #11/30/2004# I don’t get the long date
values of 11/30/2004. How can I get those values as well as the short date
values?

TIA

Steve COA-NM
 
Access stores the date/time data type as a number. The whole number part
represents the date, and the fraction part is the time of day (e.g. 6 am =
..25 = one quarter of a day).

Therefore the display format is irrelevant to the actual data, and is not
part of the matching process.

If you are not seeing the results, there must be another cause. For example,
if they entered a time component as well as the date, you won't get a match
if you search for just the date. Or if Access misunderstood the original
entry or the value to be matched, the match will not be found.
 
Back
Top