AnsweredAssumed Answered

sql: count based on < = date

Question asked by sccardais on Aug 11, 2018
Latest reply on Aug 12, 2018 by beverly

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.