Best answer by NiC
View original
Merging two date fields
+3
I 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)?
A
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.
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.
Userlevel 6
+18
Userlevel 7
+27
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>`
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>`
Leave a Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.