I think the "toFixed(2)" in the code was making it do decimals instead of commas. I tweaked to this and it worked:Qualtrics.SurveyEngine.addOnload(function() { jQuery("#number").text("$"+parseFloat("${e://Field/NameofField}") .toLocaleString("en-US"));});
var d1 = flatpickr('#d1', {});var d2 = flatpickr('#d2', {}); jQuery(document).ready(() => { jQuery('#calc').click(() => { var d1 = $('#d1').val(); var d2 = $('#d2').val(); jQuery('#dif').text(workingDaysBetweenDates(d1,d2)); });});let workingDaysBetweenDates = (d0, d1) => { /* Two working days and an sunday (not working day) */ var holidays = ['2016-05-03', '2016-05-05', '2016-05-07']; var startDate = parseDate(d0); var endDate = parseDate(d1); console.log(startDate); console.log(endDate); Qualtrics.SurveyEngine.setEmbeddedData ( "startDate", startDate ); Qualtrics.SurveyEngine.setEmbeddedData ( "endDate", endDate );// Validate input if (endDate < startDate) { return 0; }// Calculate days between dates var millisecondsPerDay = 86400 * 1000; // Day in milliseconds startDate.setHours(0, 0, 0, 1); // Start just after midnight endDate.setHours(23, 59, 59, 999); // End just before midnight var diff = endDate - startDate; // Milliseconds between datetime objects var days = M
I have not been able to get this to work, but I have learned so much and thank you to Tom for all of the help. I have gotten better luck so far using flatpickr and some jQuery to find the workdays between two dates. It seems buggy though and I can't seem to get the embedded data out. I will start a new topic as I think that's what we're supposed to do.
Is there someplace else that I should make adjustments than here? I've tried changing everything. I even separated them into new individual questions and started over on a new survey. I tried every mix of date inputs like yyyy-mm-dd, etc.
It seems to be saying "invalid date" a lot. I opened all of the drop downs for more details.
Thank you! Thank you! Thank you! The "days between" is calculating now, and the embedded data is saving... but it's coming out to zero. Any idea why? I've been playing around with the placement of embedded code and questions blocks, but still getting zero.
Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.So I can't seem to paste it and keep it's code - Is there a program you recommend? I did it in Notion and the above link should open a public page with the code block. It looks like this and then I pasted the code below but it lost its formatting. Qualtrics.SurveyEngine.addOnload(function(){{ const calcBusinessDays = (startDate, endDate) => { var startDate = moment("${q://QID13/ChoiceTextEntryValue/4}","MM/DD/YYYY");var endDate = moment("${q://QID13/ChoiceTextEntryValue/5}","MM/DD/YYYY");let BusinessDays = 0;let totalDays = moment(end).diff(moment(start), "days");let date = startfor (let i = 1; i
Thank you so much! I kept seeing people comment about "the console" and didn't know what that was. I do now and wow! I have been using it. Right now, I have this and it's not giving me errors, but I really don't know if I'm asking it to embed the correct thing at the end. I need to take the number I get here and work it into another calculation. I found a jQuery code that works to get the date calculation instead of using moment.js. - So I may switch to that if I'm not getting close. Then I will have other questions about how to pipe in the start and end date - and again, what to ask it to embed at the end. Sorry and thank you so much if anyone can help me!!!
Can anyone still help me with this? I don't have to use any of what I have. I'm open to anything that will work to give me a count of the business days between two dates.
Ah yes! That was a typo. Thanks. I fixed it, but I think I'm still far from getting this to work.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
