https://community.esri.com/t5/arcgis-survey123-questions/query-expression-not-showing-correct-date/m-p/1150442#M41057 <P>I am creating a survey that is looking for jobs that need to be picked up on the current date, to capture this I am using the Query expression <STRONG><EM>scheduledroutedate = CURRENT_DATE and Collectionstatus='In Progress'</EM></STRONG></P><P>I have found that this only works how it is supposed to (showing all of the collections for the day) in the afternoon, i think this is because the CURRENT_DATE is UTC time and being here in NZ we are a bit ahead of UTC. I was wondering if there is a way to default it to use the current date of the device being used? or if there is a better way of doing this.</P> Thu, 03 Mar 2022 22:05:09 GMT J_Arnold 2022-03-03T22:05:09Z https://community.esri.com/t5/arcgis-survey123-questions/query-expression-not-showing-correct-date/m-p/1150442#M41057 <P>I am creating a survey that is looking for jobs that need to be picked up on the current date, to capture this I am using the Query expression <STRONG><EM>scheduledroutedate = CURRENT_DATE and Collectionstatus='In Progress'</EM></STRONG></P><P>I have found that this only works how it is supposed to (showing all of the collections for the day) in the afternoon, i think this is because the CURRENT_DATE is UTC time and being here in NZ we are a bit ahead of UTC. I was wondering if there is a way to default it to use the current date of the device being used? or if there is a better way of doing this.</P> Thu, 03 Mar 2022 22:05:09 GMT https://community.esri.com/t5/arcgis-survey123-questions/query-expression-not-showing-correct-date/m-p/1150442#M41057 J_Arnold 2022-03-03T22:05:09Z