https://community.esri.com/t5/arcgis-pro-questions/query-for-days/m-p/1558247#M90097 <P>I have the below expression in an expression query.. but want to query for days not months... thoughts on how to tweak this for days?</P><LI-CODE lang="c">(( PERMITSTATUS LIKE 'COMPLETED' OR PERMITSTATUS LIKE 'CANCELED' OR PERMITSTATUS LIKE 'DENIED' OR PERMITSTATUS LIKE 'Maintenance') AND PERMITCHANGEDATE &gt;= ADD_MONTHS(TO_DATE(SYSDATE),-3))</LI-CODE> Mon, 18 Nov 2024 15:58:10 GMT kapalczynski 2024-11-18T15:58:10Z https://community.esri.com/t5/arcgis-pro-questions/query-for-days/m-p/1558247#M90097 <P>I have the below expression in an expression query.. but want to query for days not months... thoughts on how to tweak this for days?</P><LI-CODE lang="c">(( PERMITSTATUS LIKE 'COMPLETED' OR PERMITSTATUS LIKE 'CANCELED' OR PERMITSTATUS LIKE 'DENIED' OR PERMITSTATUS LIKE 'Maintenance') AND PERMITCHANGEDATE &gt;= ADD_MONTHS(TO_DATE(SYSDATE),-3))</LI-CODE> Mon, 18 Nov 2024 15:58:10 GMT https://community.esri.com/t5/arcgis-pro-questions/query-for-days/m-p/1558247#M90097 kapalczynski 2024-11-18T15:58:10Z