Hi Edward,

What is the "This" of which Startdate is a property? I suspect it is out of scope.

Try

ltStart = Dtot(This.Startdate)
CREATE SQL VIEW Temp_Agent_details CONNECTION arcview AS ;
	SELECT *;
 	FROM Agent_Details_001  ;
    	WHERE temp_agent_details.datetime = ?ltStart

pamela

>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.