Use dateofbirth to create a new variable "Generations" in the survey flow | Experience Community
Skip to main content

Use dateofbirth to create a new variable "Generations" in the survey flow

  • February 22, 2023
  • 3 replies
  • 40 views
C
Forum|alt.badge.img+1

Hello!
We have the date of birth in the embedded data. I set it up as "date" in the survey flow and it shows like this in the data tab - "Jul 1, 1990 7:00 PM". We want to create generations based on birthyear. For example, if birthyear is between 1981 and 1996, they are "Millennials".
I tried several ways using branch to create the new variable - generations, but it didn't work out. Did you have a similar experience and how do you solve it?
image.pngIn the branch, I tried using "year" or "YYYY-MM-DD".
Many thanks!
Caroline

3 replies

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+46
  • Deepak
  • February 22, 2023

https://community.qualtrics.com/XMcommunity/discussion/24094/use-dateofbirth-to-create-a-new-variable-generations-in-the-survey-flowYour branch logic is not identifying the embedded data value as a date and thinking of it as a number. Also, to achieve it in most straightforward manner you can strip the date via Javascript you can push the year in embedded data and then use branch logic for it.
Hope it helps!

C
Forum|alt.badge.img+1
  • Caroline92
  • Author
  • February 22, 2023

https://community.qualtrics.com/XMcommunity/discussion/comment/55690#Comment_55690Thank you so much for your help. I will try it!

bstrahin
Level 6 ●●●●●●
Forum|alt.badge.img+38
  • bstrahin
  • Level 6 ●●●●●●
  • February 24, 2023

Caroline92 Your survey flow makes it look like DOB is stored with a contact coming from a directory. How are users getting into your contact list? Why not have generation (a static fact about someone) added at time of adding the contacts? That would avoids having to use Javascript. It also then is a variable anyone can use across surveys with that contact rather than having to recalculate generate within each survey you send to a person.

Terms & ConditionsAccessibility statement