topic Re: Repeat inbox where clause for blank date field? in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/repeat-inbox-where-clause-for-blank-date-field/m-p/835646#M19541 <HTML><HEAD></HEAD><BODY><P>Hi Brent - try&nbsp;</P><P><STRONG style="background-color: #ffffff; border: 0px; font-weight: bold;"></STRONG></P><P><STRONG style="background-color: #ffffff; border: 0px; font-weight: bold;"><EM style="border: 0px; font-weight: inherit;">removalDate is null</EM></STRONG></P></BODY></HTML> Wed, 04 Apr 2018 05:58:26 GMT JohnathanHasthorpe 2018-04-04T05:58:26Z Repeat inbox where clause for blank date field? https://community.esri.com/t5/arcgis-survey123-questions/repeat-inbox-where-clause-for-blank-date-field/m-p/835645#M19540 <HTML><HEAD></HEAD><BODY><P>I am trying to figure out the syntax for the Inbox query that filters on whether a date field is populated or not. The form is for insect trapping and date "removalDate" is populated only when the trap is taken down <STRONG>removalDate =&nbsp; calculation (if(${confirmTakeDown} = 'y', once(today()), ''))</STRONG>, at this point I would like to remove the record from the Inbox. It seems like the query clause should be <STRONG><EM>removalDate = ''</EM></STRONG>, but this doesn't seem to work. Any thought on this would be greatly appreciated.</P></BODY></HTML> Tue, 03 Apr 2018 16:14:12 GMT https://community.esri.com/t5/arcgis-survey123-questions/repeat-inbox-where-clause-for-blank-date-field/m-p/835645#M19540 BrentKinal1 2018-04-03T16:14:12Z Re: Repeat inbox where clause for blank date field? https://community.esri.com/t5/arcgis-survey123-questions/repeat-inbox-where-clause-for-blank-date-field/m-p/835646#M19541 <HTML><HEAD></HEAD><BODY><P>Hi Brent - try&nbsp;</P><P><STRONG style="background-color: #ffffff; border: 0px; font-weight: bold;"></STRONG></P><P><STRONG style="background-color: #ffffff; border: 0px; font-weight: bold;"><EM style="border: 0px; font-weight: inherit;">removalDate is null</EM></STRONG></P></BODY></HTML> Wed, 04 Apr 2018 05:58:26 GMT https://community.esri.com/t5/arcgis-survey123-questions/repeat-inbox-where-clause-for-blank-date-field/m-p/835646#M19541 JohnathanHasthorpe 2018-04-04T05:58:26Z