Creating month, day, and year for date of birth separately in Survey123 Connect Form

Question

Hello,

I am designing a survey in Survey123 Connect and part of the questions are to collect date of birth as a month, day, and year separately, see print screen below. How can I format these questions?

Thanks!

ChristopherCounsell · Accepted Answer

I would recommend having a single date question instead of 3 separate questions. If you must have three, it suggests you have data requirements, which would dictate how you should format the questions. With no clarity on this I would recommend: * Day: Integer question, constraint for >0 and < 32 * Month:* Integer question, constraint for >0 and < 13 * Or a select_one question with a month choice list for each month * year, integer question, constraint for >1900 You could also add a list to the year/day questions and try different appearances like autocomplete.

TomWingrave · Accepted Answer

Hello,

Is the requirement to ask the question in this way (i.e. the three separate fields for Month/Day/Year) or is it to return/store the data in this way? If it is the former then Christopher's suggestion below should work great. If it is the latter then you could ask a single date time question and then have 3 hidden fields which pull the elements out into their respective fields using the format-date function.

Year; format-date(${Date_Field},'%Y')

Month; format-date(${Date_Field},'%m')

Day; format-date(${Date_Field},'%d')

Further guidance can be found under the Date formatting section on this web page; https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#:~:text=You%20can%20use%20the%20format,or%20persist%20them%20as%20strings.