Configuring date-time options

In some cases BlueConic allows you to configure a custom format for date-time options. For example, the Profile Import Connection allows you to configure a custom date format. Configuration looks like this:

date-format.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:

preview.png

Enter the date value that you want to test. The preview will display the interpreted date in the international ISO8601 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.

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 3, 2016 as the date:

Date format Date and time value
M/D/YY 3/14/16
MM/DD/YYYY 03/14/2016
YYYYMMDD 20160314
D-MMM-YY 14-Mar-16
MMMM D, YYYY March 14, 2016
M/D/YY h:mm A 3/14/16 1:30 PM
DD-MM-YYYY HH:mm:ss 14-03-2016 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