Hi everyone, I have a embedded data field with date in the format “YYYY-MM-ddZhh:mm” (example: 2024-04-23T00:00”), and I’m trying to set it this way on Qualtrics dashboard mapping, to use this field as date filter, but not having success. Also tried different syntax, like with commas (“YYYY-MM-dd,Z,hh:mm”), and other changes, none worked so far. Any tips to help? Thank you all!

Hi @warley_sYou can achieve this using JavaScript to manipulate the date string before setting it as embedded data.Here's how you can do it:javascriptQualtrics.SurveyEngine.addOnReady(function() { var embeddedDataDate = "${e://Field/YourEmbeddedDataDate}"; // Convert the date string to the format expected by Qualtrics var parts = embeddedDataDate.split("T"); var datePart = parts[0]; var timePart = parts[1].split(":"); var formattedDate = datePart.replace(/-/g, "/") + " " + timePart[0] + ":" + timePart[1] + ":00"; // Set the formatted date as embedded data Qualtrics.SurveyEngine.setEmbeddedData('FormattedDate', formattedDate); }); Replace 'YourEmbeddedDataDate' with the name of your embedded data field. This script splits the date string into date and time parts, replaces hyphens with slashes in the date part (to match the expected format), and sets the formatted date as a new embedded data field named 'FormattedDate'.Once you have the date in the correct format, you can use it as a date filter in Qualtrics dashboard mapping. Set the newly created embedded data field (FormattedDate) as a date filter, and it should work as expected.

Trouble getting a custom date format

Trouble getting a custom date format | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded