Query Looking for Date as Number

[Davenumber40]

I have a form that a user enters information in, clicks a command button and a query is executed.



The one field that isn't working is a text field where I'm trying to enter a date. If I put the date in the form I don't get a result but if I put in the number for the date (33384) the query works.

It seems like the table is storing the date as a pure number but I need to link that to a user's date entry.

Any help would be greatly appreciated.

[dsmacs]

In your query add # symbols before and after the date.

[Rawb]

If it's being stored as a Text field, there's your problem. To be able to work with dates effectively, it's best to use the Date/Time fieldtype.

If you can't change the format of your field though, you can use the DateValue() Function in your Query:

SELECT * FROM MyTable WHERE DateValue([MyTextDateField])=#07/21/2010#

The above Query will select all Records where the text field MyTextDateField, when converted to a date, equals 07/21/2010.