topic Re: Calculation: If Date Field Is Empty.... in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/calculation-if-date-field-is-empty/m-p/1055305#M34404 <P>I would start with a calculation based on field length -- something like&nbsp;<STRONG>if(string-length(${service_date_completed})&gt;0,"Completed","Open")</STRONG>.</P> Thu, 06 May 2021 17:15:39 GMT KayleeRivera 2021-05-06T17:15:39Z Calculation: If Date Field Is Empty.... https://community.esri.com/t5/arcgis-survey123-questions/calculation-if-date-field-is-empty/m-p/1055258#M34401 <P>Need help on my survey123 form.</P><P>I have a date field "service_date_completed" and a status field "service_status".</P><P>I am looking to create a calculation for the "service_status" field where, if there is a date selected for "service_date_completed", then populate with 'Completed'.&nbsp; If there is no date selected, populate with 'Open'</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 06 May 2021 15:49:59 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculation-if-date-field-is-empty/m-p/1055258#M34401 KellyArmstrong 2021-05-06T15:49:59Z Re: Calculation: If Date Field Is Empty.... https://community.esri.com/t5/arcgis-survey123-questions/calculation-if-date-field-is-empty/m-p/1055305#M34404 <P>I would start with a calculation based on field length -- something like&nbsp;<STRONG>if(string-length(${service_date_completed})&gt;0,"Completed","Open")</STRONG>.</P> Thu, 06 May 2021 17:15:39 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculation-if-date-field-is-empty/m-p/1055305#M34404 KayleeRivera 2021-05-06T17:15:39Z Re: Calculation: If Date Field Is Empty.... https://community.esri.com/t5/arcgis-survey123-questions/calculation-if-date-field-is-empty/m-p/1055306#M34405 <P>Thank you so much!</P> Thu, 06 May 2021 17:18:11 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculation-if-date-field-is-empty/m-p/1055306#M34405 KellyArmstrong 2021-05-06T17:18:11Z