SQL statements

[Guest]

I need to create a DHTML page to access an Access database. I am using an
SQL statement int the DataEnvironment that requires 2 parameters. TextField1
is the input for StartDate parameter, and TextField2 is the input for EndDate
parameter. The code I use before calling the SQL statement is "startDAte =
CDATE(TextField1)" and "endDate = CDate(TextField2)". I keep getting the
error:"Invaldi datetime format (null)". I'm not sure if I've written the sQL
statement properly. I did it through the SQL Builder.

 

[Mary Chipman]

The datetime delimiter for Access is @, not ' as in SQL Server.

--Mary