https://community.esri.com/t5/arcgis-pro-questions/sql-functions-in-definition-query-datepart/m-p/1538422#M88265 <P>Hello everyone.<BR /><BR />I've working with a big dataset stored in an enterprise geodatabase, months ago I upload a service that use a definition query that use dates as in DateField &lt;= current_timestamp - 1<BR /><BR />Now I´m wondering how to use the DATEPART function to do something similar, the expression is:<BR /><BR />Day BETWEEN 1 AND DATEPART(DAY, CURRENT_DATE)<BR /><BR />All of the keywords except "DAY" are suggested by PRO, I also tried:</P><P>DATEPART(dd, CURRENT_DATE)</P><P>DATEPART(d, CURRENT_DATE)</P><P>DATEPART(DAY FROM CURRENT_DATE)</P><P>&nbsp;</P><P>And no one works (The SQL expression has invalid syntax.), where is the issue?</P> Fri, 13 Sep 2024 17:58:13 GMT EduardoDC 2024-09-13T17:58:13Z https://community.esri.com/t5/arcgis-pro-questions/sql-functions-in-definition-query-datepart/m-p/1538422#M88265 <P>Hello everyone.<BR /><BR />I've working with a big dataset stored in an enterprise geodatabase, months ago I upload a service that use a definition query that use dates as in DateField &lt;= current_timestamp - 1<BR /><BR />Now I´m wondering how to use the DATEPART function to do something similar, the expression is:<BR /><BR />Day BETWEEN 1 AND DATEPART(DAY, CURRENT_DATE)<BR /><BR />All of the keywords except "DAY" are suggested by PRO, I also tried:</P><P>DATEPART(dd, CURRENT_DATE)</P><P>DATEPART(d, CURRENT_DATE)</P><P>DATEPART(DAY FROM CURRENT_DATE)</P><P>&nbsp;</P><P>And no one works (The SQL expression has invalid syntax.), where is the issue?</P> Fri, 13 Sep 2024 17:58:13 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-functions-in-definition-query-datepart/m-p/1538422#M88265 EduardoDC 2024-09-13T17:58:13Z