https://community.esri.com/t5/arcgis-dashboards-questions/date-data-expression/m-p/1260622#M7372 <P>Hello,</P><P>The data connected to my dashboard is a list of construction projects with start and end dates.</P><P>I am trying to write a data expression that will return a list of projects "active" on a specified date, i.e., projects in which the specified date is <EM>on or&nbsp;after</EM> the project start date and <EM>before</EM> the project end date.</P><P>Can anyone point me in the right direction? I am new to scripting.</P><P>Thank you!&nbsp;</P> Wed, 22 Feb 2023 19:21:11 GMT mshanaghan 2023-02-22T19:21:11Z https://community.esri.com/t5/arcgis-dashboards-questions/date-data-expression/m-p/1260622#M7372 <P>Hello,</P><P>The data connected to my dashboard is a list of construction projects with start and end dates.</P><P>I am trying to write a data expression that will return a list of projects "active" on a specified date, i.e., projects in which the specified date is <EM>on or&nbsp;after</EM> the project start date and <EM>before</EM> the project end date.</P><P>Can anyone point me in the right direction? I am new to scripting.</P><P>Thank you!&nbsp;</P> Wed, 22 Feb 2023 19:21:11 GMT https://community.esri.com/t5/arcgis-dashboards-questions/date-data-expression/m-p/1260622#M7372 mshanaghan 2023-02-22T19:21:11Z