Calendar with date in DD/MM/YYYY format | XM Community
Solved

Calendar with date in DD/MM/YYYY format

  • 8 February 2022
  • 13 replies
  • 1165 views

Userlevel 1
Badge

Hello,

I am attempting to use a calendar date box, I have inserted using import from library -> demographics ->calendar and date questions -> enter a date.

My only problem is this comes out in US date format MM/DD/YYYY and I need it to be in UK DD/MM/YYYY format.

Any suggestions on how to make this happen?

Happy to try flatpicker, but it has not worked for me yet. I have tried the below.

I tried adding into look and feel header:


Screen Shot 2022-02-09 at 10.39.33 PM.pngHelp 😥

icon

Best answer by Tom_1842 15 September 2023, 20:29

View original

13 replies

Userlevel 7
Badge +27

Hi,
You could try using flatpickr instead of the Qualtrics library calendar. To try it out, add the below to the Header in the survey's Look & Feel:

https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css"> src="">https://cdn.jsdelivr.net/npm/flatpickr">

Then within the survey, create a single line text entry question. Add Javascript to this survey question and add the below to the addOnReady section:

jQuery("#"+this.questionId+" .InputText").flatpickr({
 dateFormat: "d-m-Y",
});

Which should look like:
dd-mm-yyyy_flatpickr.png
Hope this helps!

Userlevel 7
Badge +27

Hi, it looks like you updated your post. The JS code you posted doesn't look like it is specifying a date format. Try adding the dateFormat piece:
jQuery("#"+this.questionId+" .InputText").flatpickr({

 dateFormat: "d-m-Y",

});

Userlevel 1
Badge

Screen Shot 2022-02-09 at 10.38.01 PM.pngWhen I use the above, this is what I get in preview.

Any suggestions?

Userlevel 7
Badge +27

Hmm, it doesn't look like your code was added as JS. Try importing the attached QSF file into a blank survey project.
Flatpickr_Datepicker.qsf

Userlevel 1
Badge

Thank you Tom, that was really helpful. I have that uploaded and it is working! Only question now is how to change this date format into D-M-Y.
You mentioned above to add this :
jQuery("#"+this.questionId+" .InputText").flatpickr({

 dateFormat: "d-m-Y",

});
I am unsure where to add this. When I select the date question on HTML view (I think this is how I add javascript?) I see the below. Where do I add the date specification to this?

What I see when I select HTML view:
Enter a date:">https://ajax.googleapis.com/ajax/libs/yui/2.9.0/build/calendar/assets/skins/sam/calendar.css"> 
 
">https://ajax.googleapis.com/ajax/libs/yui/2.9.0/build/yahoo-dom-event/yahoo-dom-event.js"> 
">https://ajax.googleapis.com/ajax/libs/yui/2.9.0/build/calendar/calendar-min.js"> 



Userlevel 7
Badge +27

Hi, Q4 in the attached QSF is collecting the date in the d-m-Y format. If you click on the symbol within the Survey Builder, you will see the JS that is in place.
Q3 is using the calendar from the Qualtrics library, and the HTML View for that question is what you posted above. I included that question more as a comparison reference, but feel free to delete it and move forward with Q4 for your project.

Userlevel 7
Badge +27

Try this QSF instead. I removed the Qualtrics calendar and made it so one of the flatpickr calendar questions is always displaying. Adjust as needed by clicking the symbol on the survey questions.
Flatpickr_DatepickerV2.qsf

Userlevel 1
Badge

Thank you! That is fantastic. I have used it and it is working perfectly.
My question now, is I have tried to import that question into my survey, and the question no longer loads with the calendar. I have imported the question directly from the Flatpickr_DatepickerV2.qsf
Uploaded Feb 11, 202210.49 KB file into my survey. Once imported, the JS is still intact in survey builder. But in preview, the calendar does not appear.

image.png
image.png

Userlevel 7
Badge +27

Glad to hear it! If you are importing the question from the Flatpickr_DatepickerV2.qsf survey into a different survey, you will likely need to also bring over the code in the Header section of the Look & Feel. Try grabbing the code in the Header section from the Flatpickr_DatepickerV2.qsf survey and adding it to your survey. Below also for reference:

Userlevel 1
Badge

Hello Tom,
Thanks for all your help so far. One other thing has crept up, the calendars are working now - but not successfully on mobile phones. It shows a box to click on on mobile phones in the preview, but not when the survey is sent out. Is there any solution for this?

To note: the calendar is still working, even when the box does not appear. If I click on the empty space below where the box should be, a calendar appears. But obviously this is difficult for those taking the survey that don't see a way forward.

Any help would be massively appreciated
Screen Shot 2022-02-28 at 10.25.09 AM.png
IMG_E5E9E5330A52-1.jpeg

Userlevel 7
Badge +27

Hmm, I am not sure I am able to recreate on my end, the calendar displays alright for me on mobile. I'd recommend going with the "inline" version of the flatpickr question so that the calendar is always displaying to the respondent regardless if the text entry box is clicked. Q5 in the attached for reference with the date format adjusted.
Flatpickr_DatepickerV3_2.qsf

Userlevel 7
Badge +27

@Anviscardi here is a QSF to import.

Badge +5

Hey Tom,

Just dropping you a line to thank you for the examples in the zip file. They are very useful indeed! I studied them and made some modifications to suit the format needed in my surveys. You are right in saying that Flatpickr makes a much better date/time picker. Really appreciate your efforts & recommendations!


I’d like to add that if I used text entry format for the date questions, I cannot see the box like other normal text entry questions in Qualtrics. However, clicking on the blank space below the question text will bring the calendar up nevertheless. In the end, I resorted to using side-by-side with open-end entry box, it then worked perfectly (showing a box).

 

Best regards,

Philip

Leave a Reply