In some cases BlueConic allows you to configure a custom format for date-time options. For example, some connections let you configure a custom date format. Configuration looks like this:
You have the option to allow BlueConic to automatically detect the date format for you, or you can set a custom date format.
- Enter a date format
- Either select one of the date formats from the list, or type the custom date format that will match your values. Valid format options are in the table below.
- Time zone
- Select the time zone that should be used when interpreting the date values upon import.
Test your input values by using the Date and time preview button:
Enter the date value that you want to test. The preview will display the interpreted date in the international ISO 8601 format. If there is a mismatch between input preview and input format, an error message to that effect is displayed.
With "Automatic detect date format" active, the preview will only recognize date values in known formats. These are the formats that are visible in the custom date format pulldown.
Using date formats with the Content Collector
When selecting date formats for the content collector, keep in mind that some web browsers interpret date formats differently. For this reason, it is recommended that you use the ISO 8601 date format with the content or product collector.
Examples
Below are a couple of working examples of date formats and the date and time values they would match to help you get started. All examples use March 14, 2021 as the date:
Date format | Date and time value |
---|---|
M/D/YY | 3/14/21 |
MM/DD/YYYY | 03/14/2021 |
YYYYMMDD | 20210314 |
D-MMM-YY | 14-Mar-21 |
MMMM D, YYYY | March 14, 2021 |
M/D/YY h:mm A | 3/14/21 1:30 PM |
DD-MM-YYYY HH:mm:ss | 14-03-2021 13:30:05 |
Input format options
Below is the list of all format matching tokens you can use to construct the text for your input format:
Token | Will match input like | |
---|---|---|
Month | M | 1 2 ... 11 12 |
Mo | 1st 2nd ... 11th 12th | |
MM | 01 02 ... 11 12 | |
MMM | Jan Feb ... Nov Dec | |
MMMM | January February ... November December | |
Quarter | Q | 1 2 3 4 |
Qo | 1st 2nd 3rd 4th | |
Day of Month | D | 1 2 ... 30 31 |
Do | 1st 2nd ... 30th 31st | |
DD | 01 02 ... 30 31 | |
Day of Year | DDD | 1 2 ... 364 365 |
DDDo | 1st 2nd ... 364th 365th | |
DDDD | 001 002 ... 364 365 | |
Day of Week | d | 0 1 ... 5 6 |
do | 0th 1st ... 5th 6th | |
dd | Su Mo ... Fr Sa | |
ddd | Sun Mon ... Fri Sat | |
dddd | Sunday Monday ... Friday Saturday | |
Day of Week (Locale) | e | 0 1 ... 5 6 |
Day of Week (ISO) | E | 1 2 ... 6 7 |
Week of Year | w | 1 2 ... 52 53 |
wo | 1st 2nd ... 52nd 53rd | |
ww | 01 02 ... 52 53 | |
Week of Year (ISO) | W | 1 2 ... 52 53 |
Wo | 1st 2nd ... 52nd 53rd | |
WW | 01 02 ... 52 53 | |
Year | YY | 70 71 ... 29 30 |
YYYY | 1970 1971 ... 2029 2030 | |
Y | 1970 1971 ... 9999 +10000 +10001 Note: This complies with the ISO 8601 standard for dates past the year 9999 |
|
Week Year | gg | 70 71 ... 29 30 |
gggg | 1970 1971 ... 2029 2030 | |
Week Year (ISO) | GG | 70 71 ... 29 30 |
GGGG | 1970 1971 ... 2029 2030 | |
AM/PM | A | AM PM |
a | am pm | |
Hour | H | 0 1 ... 22 23 |
HH | 00 01 ... 22 23 | |
h | 1 2 ... 11 12 | |
hh | 01 02 ... 11 12 | |
k | 1 2 ... 23 24 | |
kk | 01 02 ... 23 24 | |
Minute | m | 0 1 ... 58 59 |
mm | 00 01 ... 58 59 | |
Second | s | 0 1 ... 58 59 |
ss | 00 01 ... 58 59 | |
Fractional Second | S | 0 1 ... 8 9 |
SS | 00 01 ... 98 99 | |
SSS | 000 001 ... 998 999 | |
SSSS ... SSSSSSSSS | 000[0..] 001[0..] ... 998[0..] 999[0..] | |
Time zone | z or zz | EST CST ... MST PST |
Z | -07:00 -06:00 ... +06:00 +07:00 | |
ZZ | -0700 -0600 ... +0600 +0700 | |
UNIX Timestamp | X | 1360013296 |
UNIX Millisecond Timestamp | x | 1360013296123 |