Skip to main content
Skip to article
  • Qualtrics Platform
    Qualtrics Platform
  • Customer Journey Optimizer
    Customer Journey Optimizer
  • XM Discover
    XM Discover
  • Qualtrics Social Connect
    Qualtrics Social Connect

Date Field Format (CX)

Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!

About Dashboard Date Field Formats

You can customize the formats of date fields in your dashboard. This can be useful to specify what order date, year, and month come in, and to specify whether there’s time data and how you what that to appear.

Qtip: You cannot customize date formats for default date fields like Recorded Date, End Date, and Start Date. These default fields are formatted automatically.

Changing Date Formats in the Data Mapper

Qtip: The data mapper is the default, simplest way you define dashboard data. See Data Mapper (CX) for more details.

Default date fields like recorded and end date will follow the time zone of the dashboard. When creating a new date field, the default time zone selected is often GMT, the CX Dashboard default. However, it is best practice to verify the correct time zone for the new field you are adding.

  1. Add a new Date field, or navigate to an existing Date field.
    Data mapper where a date field is highlighted and to the rightmost longest column it says not mapped in light gray
  2. Click on the recode symbol.
  3. Select a Format.
    Dropdowns on a new window for setting the format

    Qtip: The list of date formats is not all inclusive. If you are using a date format that is not in the list, you’ll need to create a custom date format by selecting Custom.
  4. If you selected Custom, then you’ll write out your own format. See a guide to custom date syntax.
    clicking add to add additional formats, and then clicking apply when done. After, click save to save changes.
  5. Select a Timezone apply to your data.
  6. Click Add to add additional formats and time zones.
  7. Click Apply.
  8. Click Save to save your changes.

Changing Date Formats in Data Models

Qtip: The data modeler and related functionality is not yet available to all customers. If you’re interested in this feature, please reach out to your XM Success Representative. Qualtrics may, in its sole discretion and without liability, change the timing of any product feature rollout, change the functionality for any in preview or in development product feature, or choose not to release a product feature or functionality for any reason or for no reason.

You can only customize dates at the source in a data model. These formats are then carried through the model’s joins, unions, and output dataset.

Qtip: The time zone of your custom date fields will always match the time zone set for the dashboard.
  1. Select the source that contains the date field.
    Clicking a source in a model
  2. Select Field editor.
  3. Click the Actions button next to a date field.
  4. Select Date Format.
  5. Select the format of your dates.
    New window where you select a format
  6. If you select Custom, you can enter your own date and time format. See Date Format Syntax for a guide.
    Configuring format
  7. To save your changes, click Apply.

Date Format Syntax

To specify a custom format, please use the following symbolic syntax:

Symbol Meaning Presentation Examples
G era text AD
C century of era (>=0) number 20
Y year of era (>=0) year 1996
x weekyear year 1996
w week of weekyear number 27
e day of week number 2
E day of week text Tuesday; Tue
y year year 1996
D day of year number 189
M month of year month July; Jul; 07
d day of month number 10
a halfday of day text PM
K hour of halfday (0~11) number 0
h clockhour of halfday (1~12) number 12
H hour of day (0~23) number 0
k clockhour of day (1~24) number 24
m minute of hour number 30
s second of minute number 55
S fraction of second number 978
z time zone text Pacific Standard Time; PST
Z time zone offset/id zone –0800; –08:00; America/Los Angeles
, escape for text delimiter
‘ ‘ single quote literal ‘

 

For example, if you have date and time data in this format: Tue, 10–25–2015, 8:42pm should be presented in the date format field as E, MM–dd–yyyy, K:ma.