Change Format of Embedded Data Date

I’m disappointed there’s no response to this in a year! I, too, need to take a field that is ingested as datetime, and record it in a separate field as just date since Dashboard filters can’t use datetime fields.

​@brianj ​@KWigg , 

Qualtrics does not currently provide a built-in function within the Survey Flow to reformat an Embedded Data field value (for example, converting 2022-03-11T00:00:00.000Z to 2022-03-11) without using JavaScript or a post-survey workflow.

One approach is to add JavaScript to the first survey. When the date field is passed through the query string to the second survey, the JavaScript can format the date before storing or sending the value.

This ensures the receiving survey gets the date in the required YYYY-MM-DD format, which can then be used correctly for date-based filters and reporting.

Qualtrics.SurveyEngine.addOnload(function () {

    // Replace "EmbeddedDate" with your Embedded Data field name
    var dateValue = "${e://Field/EmbeddedDate}";

    if (dateValue) {
        // Keep only the YYYY-MM-DD portion
        var formattedDate = dateValue.split("T")[0];

        // Save it back to Embedded Data
        Qualtrics.SurveyEngine.setEmbeddedData("EmbeddedDate", formattedDate);
    }

});