Date Re-Upload Issues | XM Community
Skip to main content
Solved

Date Re-Upload Issues

  • September 17, 2020
  • 4 replies
  • 1039 views
Martin_O
Level 2 ●●
Forum|alt.badge.img+11

Hello,
I am trying to re-upload a date field from a csv into Qualtrics so that it matches the format of my date optioned embedded data field ${date://CurrentDate/DS}. I am doing this with hopes that I can have one FILTERABLE date location that doesn't get messed up during uploads like the Metadata date fields do. I have tried so many formats in an effort to upload but it just won't allow me to successfully import. If I open my data in a text editor for that column it shows the format 2020-09-17 17:13:56 (although excel recognizes any date field as m/d/yy h:mm) How do I have to format my cells so that it will import? I have tried several ways including YYYY-MM-MM HH:mm:ss. Also, is there anything that can be done with ${date://CurrentDate/DS} such as using -6 or something to account for the UTC time difference format? How would that be written? This isn't a must for me, but it would be nice as our department likes to filter by an accurate timestamp.

Best answer by PraDeepKotian_XM

I used to follow the format yyyy-mm-dd HH:mm:ss and its works well for me however, in some cases to getting the date in this format is a complex task. I usually try saving the csv file in csv UTF-8 format so that it retains the format even after we close the csv file.

    4 replies

    ana_velez
    QPN Level 5 ●●●●●
    Forum|alt.badge.img+27
    • ana_velez
    • QPN Level 5 ●●●●●
    • September 23, 2020

    Hi!
    This has always been an issue for us. I beleive the right one is MM-DD-YYYY, however in the CSV uploader you can select the format. This is what is stated in support page

    • Date/Time Format: Determine the date/time format of the whole data file. If you exported the file from Qualtrics, the importer will try to detect the timezone you set on your account at the time the file was exported.


    https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/import-responses/

    Ana Vl
    MsIreen
    MsIreen
    Level 5 ●●●●●
    Forum|alt.badge.img+23
    • MsIreen
    • Level 5 ●●●●●
    • September 23, 2020

    Same as ana_velez_voce I have always been struggling with this... I am using the highlighted format:
    image.pngThe funny thing is that I set the date in this format in a csv file, save and do not close the file. For some reason if I close it before uploading, the date format goes completely wrong🙄

    PraDeepKotian_XM
    QPN Level 5 ●●●●●
    Forum|alt.badge.img+21
    • PraDeepKotian_XM
    • QPN Level 5 ●●●●●
    • Answer
    • September 23, 2020

    I used to follow the format yyyy-mm-dd HH:mm:ss and its works well for me however, in some cases to getting the date in this format is a complex task. I usually try saving the csv file in csv UTF-8 format so that it retains the format even after we close the csv file.

    Martin_O
    Martin_O
    Level 2 ●●
    Forum|alt.badge.img+11
    • Martin_O
    • Author
    • Level 2 ●●
    • October 6, 2020

    Thanks so much everybody on this thread as well as TomG . All of your suggestions were very helpful. Here is what I found that worked best for this issue:
    PraDeepKotian_Ugam 's UTF-8 suggestion was key for this. Also TomG recently recommended the date optioned field ${date://CurrentDate/c}. This was important because when it comes to reporting it recognizes the timezone correctly. ${date://CurrentDate/DS} works as well, but didn't adjust the timezone. Here was the main thing for me. When looking at the dates in Data & Analysis it will just show the date "Oct 6, 2020" without a timestamp but if you want to use this in reporting or on export, whenever I added that it gave me the correct timestamp as is shown like in Start Date, End Date, Recorded Date which is also filterable. ${date://CurrentDate/DS} didn't adjust the timezone. The drawback is if you want to filter by timestamp in Data and Analysis but at least you get a filterable field. Thanks again everybody!

    PraDeepKotian_XM
    Terms & ConditionsAccessibility statement