Merging two date fields | XM Community
Skip to main content
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)?
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.
Hey @brmckim ,



Please follow this thread



Change numeric values (e.g if it has > 6 , make it > 2) in java file as per your requirement.



And add an embedded data go to option and select variable type as Date.



Oops..! sorry I understood your query now..
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>`

Leave a Reply