data type mismatch on date field from form in my sql query

[MM70]

I am having a hard time getting my sql query to accept a date value in the WHERE clause.

The date is being input by the user on a form (textbox formatted as short date)

The date which is being refrenced to in the query resides on another table on a server. I linked the table in my access project and when i open it up to look at the field propeties the date format is listed as "date/time".

I guess my question is how do i figure out what format the date is stored on the external table and how do i format the date the user inputs in the form so my sql query will accept the value in the WHERE clause and not give me the mismatch?

Been searching google and the forums for a while and nothing has been working....

 

[MM70]

Ok i have figured out that the remote server i am querying has the date stored as smalldatetime. What format do i need to make the textbox on the form where the user inputs the date they want to search, so i can get it to return all records for that date (don't care about the time).