I am trying to talk to an Access backend. I know that the data that I am trying to use as a filter criteria is an Access datetime type and I know that I have to use "access-speak", but I don't know how to do this.

Example: arcview is the ODBC connection to the Access database and Agent_Details_001 is the Access table. I store the date that I want to extract in this.startdate.

CREATE SQL VIEW Temp_Agent_details CONNECTION arcview AS ;
SELECT *;
FROM Agent_Details_001 ;
WHERE TTOD(temp_agent_details.datetime) = ?this.startdate


How can I make this work?

Thanks for your help.