Macro Creating a variable which is to be used in a SQL in the Mac
 

Created a variable by using an input box

eg. StartDate = InputBox("Enter Start Date?", "Report")

Then used this variable in the where clause of the SQL statemnt in the Macro

eg Date StartDate

Instead of using the variable it tried to put StartDate in the query instead.

How do i make the statement to look at the variable.

Should the format be in a datetime format as well since this field in the
database is of datetime format. How do i then change the variable to a
datetime format

Thanks to anyone who can help