DateAdd SQL Code Syntax error

Question

i keep getting the below error when running this SQL code in an access query. Any idea why?

Error: Syntax error (missing operator) in query expression ' Status Date'

Code:

FROM [Owner Training Report]
WHERE ((([Owner Training Report].[Status Date])>DateAdd("m",12,Date())) AND (([Owner Training Report].[Reporting Basic Status])="Completed"));

Please show full SQL as error can be due to another part of query. — Parfait
– Parfait, Commented Nov 1, 2017 at 19:18

Gustav · Accepted Answer · 2017-11-02 08:42:22Z

1

You may have Null values, so try:

WHERE (Nz([Status Date],Date()) > DateAdd("m",12,Date())) AND ([Reporting Basic Status] = "Completed");

answered Nov 2, 2017 at 8:42

Gustav

56.3k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrey Belykh · Accepted Answer · 2017-11-01 19:26:40Z

0

Try this (I cannot be 100% sure as I don't know what is your full query):

FROM [Owner Training Report]
WHERE ((([Owner Training Report].[Status Date])>DateAdd('m',12,Date())) AND (([Owner Training Report].[Reporting Basic Status])='Completed'));

I basically changed " to '

answered Nov 1, 2017 at 19:26

Andrey Belykh

2,6744 gold badges36 silver badges51 bronze badges

Collectives™ on Stack Overflow

DateAdd SQL Code Syntax error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related