topic Can you Format a Query Definition on a Date/Time Field to get just the last day not the last 24 hrs. in ArcGIS Dashboards Questions https://community.esri.com/t5/arcgis-dashboards-questions/can-you-format-a-query-definition-on-a-date-time/m-p/564229#M3105 <HTML><HEAD></HEAD><BODY><P>Can you Format a Query Definition on a Date/Time Field to get just the last day not the last 24 hrs.&nbsp; When I do a query that says. </P><P></P><P><EM style="text-decoration: underline;">FinishDateTime Is within the last 1 days</EM></P><P></P><P>I get the last the 24 hours.&nbsp;&nbsp; I need to get it to stop at midnight.&nbsp; Any ideas? </P><P></P><P>Shane </P></BODY></HTML> Wed, 28 Jan 2015 21:27:47 GMT ShaneLim 2015-01-28T21:27:47Z Can you Format a Query Definition on a Date/Time Field to get just the last day not the last 24 hrs. https://community.esri.com/t5/arcgis-dashboards-questions/can-you-format-a-query-definition-on-a-date-time/m-p/564229#M3105 <HTML><HEAD></HEAD><BODY><P>Can you Format a Query Definition on a Date/Time Field to get just the last day not the last 24 hrs.&nbsp; When I do a query that says. </P><P></P><P><EM style="text-decoration: underline;">FinishDateTime Is within the last 1 days</EM></P><P></P><P>I get the last the 24 hours.&nbsp;&nbsp; I need to get it to stop at midnight.&nbsp; Any ideas? </P><P></P><P>Shane </P></BODY></HTML> Wed, 28 Jan 2015 21:27:47 GMT https://community.esri.com/t5/arcgis-dashboards-questions/can-you-format-a-query-definition-on-a-date-time/m-p/564229#M3105 ShaneLim 2015-01-28T21:27:47Z