Date Field Format (CX)
What's on This Page:
Changing a Field’s Date Format
- Add a new Date field, or navigate to an existing one that is a Date Field Type.
- Make sure it is mapped. If not, select where it says Not Mapped and select the corresponding field from your source.
- Click on the recode symbol.
- Define which Format and Time Zone apply to your data.
- Click Add to add additional formats and timezones.
- Click Save.
Adding a Custom Date Format
- Add a new Date field, or navigate to an existing one that is a Date Field Type.
- Make sure it is mapped. If not, select where it says Not Mapped and select the corresponding field from your source.
- Click on the recode symbol.
- Select Custom.
- Enter in your own custom format.
- Click Save when finished.
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.
Timezones
The Time Zone option is generally set to the timezone of your Qualtrics account. However, it is best practice to verify the correct timezone for the field you are adding.