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

[Almaz_Naizghi]

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 solution]

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.

[Almaz_Naizghi]

Thank you for your quick response and recommendation.

I will try to convince the team who are requesting the survey to get a single date entry instead of 3 separate questions.

[TomWingrave · Accepted solution]

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%20u.... 

[Almaz_Naizghi]

Thank you for your prompt reply!

To answer your question the request was the former to get three separate fields for month/day/year.

As, Christopher's suggested it is better to get one date entry instead of three separate fields.