AnsweredAssumed Answered

comparing date is throwing error

Question asked by tnarladni on Nov 6, 2019

I want to create a definition query to only view records where the month is 1 month ahead from current month. So for November, I want to view all December recrods, regardless of day.



Because it's the end of the year, I would have to account for the year as well so I wrote this:

format(DUE_DATE, 'yyMM') > format(DUE_DATE, 'yyMM')+1

This works when I write a sql select statement with a where clause in sql management studio on the table, but i'm getting syntax errors in the definition query dialog. 


Please help.