Calculation: If Date Field Is Empty....

1065
2
Jump to solution
05-06-2021 08:49 AM
KellyArmstrong
Occasional Contributor II

Need help on my survey123 form.

I have a date field "service_date_completed" and a status field "service_status".

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'.  If there is no date selected, populate with 'Open'

 

 

0 Kudos
1 Solution

Accepted Solutions
KayleeRivera
Esri Contributor

I would start with a calculation based on field length -- something like if(string-length(${service_date_completed})>0,"Completed","Open").

View solution in original post

2 Replies
KayleeRivera
Esri Contributor

I would start with a calculation based on field length -- something like if(string-length(${service_date_completed})>0,"Completed","Open").

KellyArmstrong
Occasional Contributor II

Thank you so much!

0 Kudos