I'm sure this is a basic query but I could use some help because I rarely use SQL.
I want to count the number of records where the value in a date field "date_ordered" is < = to a specified date.
The base table is ADMIN
The date field is ADMIN::date_ordered
This is my query and resulting error. NOTE: The example below hard codes a date but I would want to replace this with a variable.