topic comparing date is throwing error in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/comparing-date-is-throwing-error/m-p/684175#M30263 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P></P><P>Because it's the end of the year, I would have to account for the year as well so I wrote this:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>format(DUE_DATE, 'yyMM') &gt; format(DUE_DATE, 'yyMM')+1</P></BLOCKQUOTE><P>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.&nbsp;</P><P></P><P>Please help.</P></BODY></HTML> Wed, 06 Nov 2019 20:47:57 GMT tnarladni 2019-11-06T20:47:57Z comparing date is throwing error https://community.esri.com/t5/arcgis-pro-questions/comparing-date-is-throwing-error/m-p/684175#M30263 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P></P><P>Because it's the end of the year, I would have to account for the year as well so I wrote this:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>format(DUE_DATE, 'yyMM') &gt; format(DUE_DATE, 'yyMM')+1</P></BLOCKQUOTE><P>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.&nbsp;</P><P></P><P>Please help.</P></BODY></HTML> Wed, 06 Nov 2019 20:47:57 GMT https://community.esri.com/t5/arcgis-pro-questions/comparing-date-is-throwing-error/m-p/684175#M30263 tnarladni 2019-11-06T20:47:57Z