I've created a subscription form in MC Cloud Pages in which users can sign up for a newsletter and can also fill in their first name, last name and date of birth. The date of birth field consists of three drop-down fields, one each for day, month, and year. When the form is submitted, the day, month and year are inserted into the Data Extension in Marketing Cloud as separate values. I want to merge these fields into one Date of Birth field.
Is is possible to create a dateOfBirth field in the data extension where the 3 values of day, month and year are merged into?