I am trying to write a simple query that will count the number of orders which were complete for a given date range. I am using the SQL queries module. I am stuck on the proper syntax for the query's where clause. I tried this and got an error:
where
tisfc001.cmdt between tcdate.f and tcdate.t
I thought that this should bring up a request for the two dates.

Am I wrong?

Probably yes.

I think you should rather have:
tisfc001.cmdt >= tisfc001.cmdt.f and
tisfc001.cmdt <= tisfc001.cmdt.t

It works perfectly thank you.

This is where clause is basically correct:
where
tisfc001.cmdt between tcdate.f and tcdate.t
except variables need a colon (:) preceding them as shown.
where
tisfc001.cmdt between :tcdate.f and :tcdate.t
This statement will compile without errors now.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.