Incorrect syntax near the keyword 'FROM'

[ChrisPolley]

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'

[JenniferMcCall4]

Have you tried breaking up the statement into smaller individual statements to see which section has the error?

[ChrisPolley]

Yes and no

[JoshuaBixby]

It seems EXTRACT is working and CURRENT_DATE, is the issue with the DateReported field?  Does this work?

• (EXTRACT(YEAR FROM "DateReported"))

[DarrenWiens2]

Can you get it to work for a simpler expression (e.g. "EXTRACT(YEAR FROM "DateReported")=2010")?

[JoshuaBixby]

What about moving the right-parenthesis over to before the less than comparison:

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

[ChrisPolley]

Tried that and I'm getting the same error.

[DanPatterson_Retired]

do the following and tell if it works

• (EXTRACT(YEAR FROM CURRENT_DATE))      - note the brackets!
• ((EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM "DateReported"))  < 10 )    - ditto!!

If either fails, let us know which one... build the steps incrementally and manually watching that you may need to add brackets as I have done in the above 2 examples