Calculate DOB in excel for Survey123 Connect

Question

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)

FrankyMiller · Answer

Finnish people can read more about calculator on my website.

JamesBorders · Answer

We can calculate DOB by using an online age calculator.

JohnHasthorpe · Answer

Hi Eric

Add the following to the calculate field of a text or note question:

format-date(${DOB},'%m/%d/%Y')

This will be for display purposes only, but can be persisted in the feature service as a text field.

Please see the following: https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis for more info.

Cheers

John