I am having trouble understanding how to treat a variable assigned with a date.
As an example:

zdate = 03/17/2003

when I try to use this in a SELECT statement zdate is recognized as an integer
and Access won't consider it a valid date and no records are found. If I try
this:

strSQL = "SELECT * FROM Times WHERE appDate = '"&zdate&"'"

so that the value is a string I get [Microsoft][ODBC Microsoft Access Driver]
Data type mismatch in criteria expression.