I am trying to embed a Date field in the survey flow

ChadMChadM Salt Lake City, UTCommunity Member Qubie ✭

I am trying to embed a Date field in the survey flow

I successfully imported data into a live survey from a csv file. The first header on the csv file is the Submission Date.
The import Qualtircs "Recorded Date" is correct because it's the day I imported but the date I received the imported csv files date back 6 months. I want to capture the actual date our customers submitted the survey using our old syste.

I tried to create an embedded field for "Date" in the survey flow but I might have put it in the wrong place and/or set it up wrong. Has someone successfully done this and could share your knowledge. Screen shots would be awesome

Best Answers

  • AkdashboardAkdashboard South Carolina Superuser ✭✭✭✭
    Accepted Answer

    @ChadM - Is your issue that you exported survey results, then imported them in to a survey and lost the historic Recorded Date because it is being overwritten with the uploaded date?

    If so, what you need to do is add a new embedded data field to your survey flow (call it ActualRecordedDate or whatever) then re-import your csv and map the previous Recorded Date to this new field. I would also recommend making (ActualRecordedDate) equal to Recorded Date using piped text in the survey flow. That way you always have one field to reference.

  • Michael_Campbell_RedPepperMichael_Campbell_RedPepper Pleasant Grove, UT Sage ✭✭✭
    Accepted Answer

    When importing a date, there is a part where you can determine the format of the date. If that doesn't line up with your imported date format, you will run into issues. Another potential snag point is if your timezone isn't set, or doesn't match the import: https://www.qualtrics.com/support/survey-platform/managing-your-account/research-core-account-settings/#UserSettings

Answers

  • ChadMChadM Salt Lake City, UTCommunity Member Qubie ✭

    Thanks Michael. Do I make those format edits in the survey flow module?

  • ChadMChadM Salt Lake City, UTCommunity Member Qubie ✭

    Akdashboard,

    Yes you are correct. I want to keep the actual submission date behind this legacy data. I haven't tried using piped text. I'll give it a shot.

  • AkdashboardAkdashboard South CarolinaCommunity Member Superuser ✭✭✭✭

    @ChadM - Yeah, that is what you will want to do then. It is annoying, but I run in to this problem every so often and this is the best solution I have found.

  • Michael_Campbell_RedPepperMichael_Campbell_RedPepper Pleasant Grove, UTQualtrics Partner Sage ✭✭✭

    If you are familiar with Javascript, I recommend Moment.js - it has all the tools needed to take the complexity out of Date formatting.

Sign In to Comment