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.

 

Outcomes