Solved
Merging two date fields
+3I ask for date of birth in three separate fields: I ask year of birth (YYYY) in the first survey, and then I ask for month (MM) and day (DD) in a follow-up survey. How can I merge the responses into a single date field (MM/DD/YYYY)?
Best answer by NiC
hi @brmckim
If you have not started taking responses , you can pass the year as data into the follow up survey using the query strings eg `<followupsurveylink>?D_Year=<pipe in the year>.`
In the follow up survey :
* in survey flow create an embedded data you want to store date in
* In its value we will pipe in the date as shown below!
` <pipedMM>/<pipedDD>/<pipedYEAR>`
` <pipedMM>/<pipedDD>/<pipedYEAR>`Hello @brmckim ,
Assuming you have a common question(like email etc) in your survey through which you can track the respondent uniquely.
You can export the responses from different surveys in csv and using excel manually filter and merge the columns of the dates.
+18
+27hi @brmckim
If you have not started taking responses , you can pass the year as data into the follow up survey using the query strings eg `<followupsurveylink>?D_Year=<pipe in the year>.`
In the follow up survey :
* in survey flow create an embedded data you want to store date in
* In its value we will pipe in the date as shown below!
` <pipedMM>/<pipedDD>/<pipedYEAR>`
` <pipedMM>/<pipedDD>/<pipedYEAR>`Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.