Calculating age based on DOB - Embedded Data now showing up or updating | Experience Community
Skip to main content
Question

Calculating age based on DOB - Embedded Data now showing up or updating

  • September 21, 2020
  • 8 replies
  • 1119 views
G

Hi all,
I have been follwoing responses by TomG to several questions about calculating age from a given DOB and it seems to work for everyone However, none of mine seem to work. So I am asking for some help. For reference this is the most complete theread I found and a snipet of the code bellow: https://www.qualtrics.com/community/discussion/1397/javascript-to-calculate-users-age-based-on-dob-check-age-eligibility-provide-validation-alert/p2
Qualtrics.SurveyEngine.addOnPageSubmit(function() {
var age = moment().diff(moment(jQuery("#"+this.questionId+" .InputText").val()), 'years');
Qualtrics.SurveyEngine.setEmbeddedData('age', age);
if(age > 18) Qualtrics.SurveyEngine.setEmbeddedData('eligible', '1');
});
My embedded variables like age and eligible do not seem to update regardless of the DOB I give it. I tried just printing the Embedded Data in a text field, and it just shows me empty space. I had the moment.js link in the header, and I use the exact code as above about calculating difference and setting eligible; I included the embedded data before the actual block of where the question is; I even tried using Day.js as an alternative in a following text segment, using the response of the date input:
Qualtrics.SurveyEngine.addOnload(function()
{
    /*Place your JavaScript here to run when the page loads*/
        var  given_age = dayjs("${q://QID62/ChoiceTextEntryValue}").format("MM/DD/YYYY");
    
    var curr_date = dayjs().format("MM/DD/YYYY");
    var age = curr_date.diff(given_age, 'year') ;
    Qualtrics.SurveyEngine.setEmbeddedData('age', age);
    

});
But the embedded data never shows and the branching I try to add at the end . It seems I am missing something compeltely obvious, but JS is on the newer languages for me. Any help would be appreciated!🙂

    8 replies

    TomG
    Level 8 ●●●●●●●●
    Forum|alt.badge.img+27
    • TomG
    • Level 8 ●●●●●●●●
    • September 21, 2020

    gre74 ,
    Provide a preview link to a survey with the moment example above.

    G
    • gre74
    • Author
    • September 21, 2020

    https://www.qualtrics.com/community/discussion/comment/30410#Comment_30410Thanks for finding the time to look it over. I have sent you a message

      C
      Forum|alt.badge.img+1
      • Christin
      • September 27, 2020

      hi! Were you able to solve your issue? I'm trying to create Age from an Embedded Data Field "Date of Birth" (MM/DD/YYYY format) and am so lost after searching in the community results. I want to create Age simply for reporting purposes in dashboard. Not sure where to create it in survey project or how.

      TomG
      Level 8 ●●●●●●●●
      Forum|alt.badge.img+27
      • TomG
      • Level 8 ●●●●●●●●
      • September 27, 2020

      https://www.qualtrics.com/community/discussion/comment/37094#Comment_37094https://www.qualtrics.com/community/discussion/comment/37094#Comment_37094https://www.qualtrics.com/community/discussion/comment/30631#Comment_30631Specifying the date format when parsing the birth date solved gre74's issue:
      var bdate = moment(jQuery("#"+this.questionId+" .InputText").val(),"MM/DD/YYYY");

      U
      Level 3 ●●●
      Forum|alt.badge.img+5
      • uhrxx005
      • Level 3 ●●●
      • January 11, 2021

      Hi TomG

      Pardon my Javascript ignorance, but I am also trying to get this to work with a text entry question using date content validation and it is not filling in the "age" Embedded Data variable.

      I have this JS in the question:
      Qualtrics.SurveyEngine.addOnPageSubmit(function() {
      var age = moment().diff(moment(jQuery("#"+this.questionId+" .InputText").val()), 'years');
      Qualtrics.SurveyEngine.setEmbeddedData('age', age);
      if(age > 18) Qualtrics.SurveyEngine.setEmbeddedData('eligible', '1');
      });

      In the header I have this code:


      Where would I add the snippet? Do I add it within the Question Javascript?
      "ar bdate = moment(jQuery("#"+this.questionId+" .InputText").val(),"MM/DD/YYYY");

      Thanks!

      U
      Level 3 ●●●
      Forum|alt.badge.img+5
      • uhrxx005
      • Level 3 ●●●
      • January 11, 2021

      TomG you can disregard my previous message. The issue was I pasted in the header code from your previous post and qualtrics blocked the email address in there. Thanks for providing this solution though!

      M
      • MrBroch
      • May 4, 2021

      I've been successful in implementing TomG 's moment.js date calculation, but I am facing the same issue where I cannot get it to work on a DD/MM/YYY format, only on a MM/DD/YYYY format.
      Currently, my code (as provided by TomG ) looks like this:
      Qualtrics.SurveyEngine.addOnPageSubmit(function() {
        var age = moment().diff(moment(jQuery("#"+this.questionId+" .InputText").val()), 'years');
        Qualtrics.SurveyEngine.setEmbeddedData('age', age);
      });

      Unfortunately, my very limited understanding of Javascript is preventing me from successfully changing the function to work with the DD/MM/YYY format. How would I implement this solution in my code:
      https://www.qualtrics.com/community/discussion/comment/30632#Comment_30632

      TomG
      Level 8 ●●●●●●●●
      Forum|alt.badge.img+27
      • TomG
      • Level 8 ●●●●●●●●
      • May 5, 2021

      https://www.qualtrics.com/community/discussion/comment/37094#Comment_37094var bdate = moment(jQuery("#"+this.questionId+" .InputText").val(),"DD/MM/YYYY");

      Terms & ConditionsAccessibility statement