topic Re: ArcMap - Definition query using dates to select current week in Developers Questions https://community.esri.com/t5/developers-questions/arcmap-definition-query-using-dates-to-select/m-p/266092#M1717 <HTML><HEAD></HEAD><BODY><P>Some good discussion here:&nbsp; <A class="link-titled" href="https://stackoverflow.com/questions/23051197/how-to-get-data-of-current-week-only-in-sql-server" title="https://stackoverflow.com/questions/23051197/how-to-get-data-of-current-week-only-in-sql-server">how to get data of current week only in SQL server? - Stack Overflow</A> .&nbsp; The discussion is focused on SQL Server but Postgres also has a DatePart function (<A class="link-titled" href="https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT" title="https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT">PostgreSQL: Documentation: 12: 9.9.&nbsp;Date/Time Functions and Operators</A>&nbsp;).</P></BODY></HTML> Wed, 27 May 2020 18:36:36 GMT JoshuaBixby 2020-05-27T18:36:36Z ArcMap - Definition query using dates to select current week https://community.esri.com/t5/developers-questions/arcmap-definition-query-using-dates-to-select/m-p/266091#M1716 <HTML><HEAD></HEAD><BODY><P>I would like to write a definition query expression to get features where a date field is in the current week (starting Sunday ending Saturday)</P><P></P><P>I have difficulties to imagine how using CURRENT_DATE would help me in that case.</P><P></P><P>I want the definition expression to returns the same features from Sunday to Saturday.</P><P></P><P>My feature class is stored in PostGreSQL (ArcGIS Enterprise)</P></BODY></HTML> Wed, 27 May 2020 17:01:24 GMT https://community.esri.com/t5/developers-questions/arcmap-definition-query-using-dates-to-select/m-p/266091#M1716 MaximeDemers 2020-05-27T17:01:24Z Re: ArcMap - Definition query using dates to select current week https://community.esri.com/t5/developers-questions/arcmap-definition-query-using-dates-to-select/m-p/266092#M1717 <HTML><HEAD></HEAD><BODY><P>Some good discussion here:&nbsp; <A class="link-titled" href="https://stackoverflow.com/questions/23051197/how-to-get-data-of-current-week-only-in-sql-server" title="https://stackoverflow.com/questions/23051197/how-to-get-data-of-current-week-only-in-sql-server">how to get data of current week only in SQL server? - Stack Overflow</A> .&nbsp; The discussion is focused on SQL Server but Postgres also has a DatePart function (<A class="link-titled" href="https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT" title="https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT">PostgreSQL: Documentation: 12: 9.9.&nbsp;Date/Time Functions and Operators</A>&nbsp;).</P></BODY></HTML> Wed, 27 May 2020 18:36:36 GMT https://community.esri.com/t5/developers-questions/arcmap-definition-query-using-dates-to-select/m-p/266092#M1717 JoshuaBixby 2020-05-27T18:36:36Z Re: ArcMap - Definition query using dates to select current week https://community.esri.com/t5/developers-questions/arcmap-definition-query-using-dates-to-select/m-p/1301731#M6651 <P>The solution I have found with Postgres</P><LI-CODE lang="sql">EXTRACT(WEEK FROM mydatefield) = EXTRACT(WEEK FROM CURRENT_DATE) + 1 AND EXTRACT(YEAR FROM mydatefield) = EXTRACT(YEAR FROM CURRENT_DATE)</LI-CODE><P>&nbsp;</P> Wed, 21 Jun 2023 20:09:08 GMT https://community.esri.com/t5/developers-questions/arcmap-definition-query-using-dates-to-select/m-p/1301731#M6651 MaximeDemers 2023-06-21T20:09:08Z