Hello,Does anyone know how to calculate approximate age using the following side by side question design in the simple layout using Javascript? i.e., Assuming all respondents are born in the middle of the month.The question asks for the month and year respondents were born, but not the day/date they were born.

Try this:Do check the id’s and update as requiredDo load jQuery in header by including<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>the embedded data would be__js_CalculatedAgeQualtrics.SurveyEngine.addOnload(function() {var qid= this.questionId; // Attach event listener to both dropdowns (assuming similar structure for year) jQuery('#question-'+qid).find(".menu-item").click(function() { setTimeout(calculateAge, 100); // Delay to allow selection update }); function calculateAge() { // Get selected month text let selectedMonthText = jQuery("#select-menu-sbs-dropdown-"+qid+"-1-1 .menu-item.selected .rich-text").text().trim(); let selectedYearText = jQuery("#select-menu-sbs-dropdown-"+qid+"-1-2 .menu-item.selected .rich-text").text().trim(); if (!selectedMonthText || !selectedYearText || selectedMonthText === "Select one" || selectedYearText === "Select one") { return; // Ensure both values are selected } // Convert month name to number const monthMap = { "January": 1, "February": 2, "March": 3, "April": 4, "May": 5, "June": 6, "July": 7, "August": 8, "September": 9, "October": 10, "November": 11, "December": 12 }; let selectedMonth = monthMap[selectedMonthText] || 0; let selectedYear = parseInt(selectedYearText, 10); if (!selectedMonth || !selectedYear) return; // Assume birth date is the 15th of the selected month let birthDate = new Date(selectedYear, selectedMonth - 1, 15); let today = new Date(); // Calculate age let age = today.getFullYear() - birthDate.getFullYear(); let monthDiff = today.getMonth() - birthDate.getMonth(); // Adjust age if birth month hasn't been reached yet if (monthDiff < 0 || (monthDiff === 0 && today.getDate() < 15)) { age--; } // Save to Qualtrics Embedded Data if needed Qualtrics.SurveyEngine.setJSEmbeddedData("CalculatedAge", age);console.log(age) }});

See if this code works for you:Qualtrics.SurveyEngine.addOnReady(function () {const quest = this;const qc = quest.getQuestionContainer();const today = new Date();const currentMonth = today.getMonth() + 1;const currentYear = today.getFullYear();const monthMapper = { Jan: 1, Feb: 2, Mar: 3, Apr: 4, May: 5, Jun: 6, Jul: 7, Aug: 8, Sep: 9, Oct: 10, Nov: 11, Dec: 12 };const getOptionValue = function (selector) {const el = qc.querySelector(selector);const value = el.value;const text = el.options[value].innerHTML;return text;};const getAge = function () {// Get values from the respective dropdownsconst dobMonth = monthMapper[getOptionValue(".SBS1 select")];const dobYear = parseInt(getOptionValue(".SBS2 select"));const monthDiff = (currentYear - dobYear) * 12 - dobMonth + currentMonth;// Calculate different EDsconst ageDecimal = Number((monthDiff / 12).toFixed(30));const ageExtraMonths = monthDiff % 12;const ageYearsOnly = (monthDiff - ageExtraMonths) / 12;const ageYearMonth = [ageYearsOnly, ageExtraMonths];// Store different ages as their respective EDsQualtrics.SurveyEngine.setEmbeddedData("monthDiff", JSON.stringify(monthDiff));Qualtrics.SurveyEngine.setEmbeddedData("ageDecimal", JSON.stringify(ageDecimal));Qualtrics.SurveyEngine.setEmbeddedData("ageExtraMonths", JSON.stringify(ageExtraMonths));Qualtrics.SurveyEngine.setEmbeddedData("ageYearsOnly", JSON.stringify(ageYearsOnly));Qualtrics.SurveyEngine.setEmbeddedData("ageYearMonth", JSON.stringify(ageYearMonth));};// Add listeners to update the ED on every selectionqc.querySelector(".SBS1 select").oninput = getAge;qc.querySelector(".SBS2 select").oninput = getAge;});

Calculating AGE from MM and YYYY (not DD) collected via a side by side question using Javascript

Calculating AGE from MM and YYYY (not DD) collected via a side by side question using Javascript | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded