AnsweredAssumed Answered

Calculate DOB in excel for Survey123 Connect

Question asked by jhpatrol on Nov 28, 2017
Latest reply on Nov 29, 2017 by JHasthorpe-esristaff

I currently calculate DOB using the format example "December 20, 1965" but I would like the format to be like this "12/20/1965" 

 

Current calc looks like this, where "DOB" is the linked field

int((decimal-date-time(today()) - decimal-date-time(${DOB})) div 365.25)

Outcomes