AnsweredAssumed Answered

Incorrect syntax near the keyword 'FROM'

Question asked by Chrisp_Summit on Oct 1, 2015
Latest reply on Oct 2, 2015 by bixb0012

i'm having an issues here, I'm trying to Select by attributes and using the following

 

(EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM "DateReported") < 10) AND "Facility" = 'Main' AND  ("Cause" = 'Other' OR "DateRepaired" IS NULL)

 

and I'm getting the following error

 

Incorrect syntax near the keywrod 'FROM'

Outcomes