date field

[Jean-Paul]

Hi,
Have following problem:
When I enter a date in a field and base my query upon this field, I get
no result.
I noticed, when I enter a date like 01/05/08 (the format=dd/mm/yy) acces
actually stores it like 010508, so in the query, of course I get no
results because I think the query doesn't see this like a date.

How to solve this?
Thanks

 

[Douglas J. Steele]

Sounds as though you're storing the date in a text field, not a date field,
and that you're using an input mask.

If you were storing the date in a date field, it would be stored as an eight
byte floating point number, where the integer portion represents the date as
the number of days relative to 30 Dec, 1899 and the decimal portion
represents the time as a fraction of a day. For instance, 01 May, 2008 would
be stored as 39569. By doing that, the format doesn't enter into it.

 

[Jean-Paul]

The field is unbound.....
I created a form with 2 entryfields, added a pushbutton which runs a
query based upon the values of the 2 (date) entryfields.
JP

 

[Tieske]

you might also want to check this out regarding dates and SQL:
http://www.mvps.org/access/datetime/date0005.htm

regards
Tieske

 

[Douglas J. Steele]

What's the query?