Help Center

Configuring date-time options

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:

How to configure date and time formats in the BlueConic customer data platform.png

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:

How to test input values for custom date and time formats in BlueConic

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
Was this article helpful?
0 out of 0 found this helpful