Use a date field in the import mapping

If you have an import in Channable that contains a field with a date in it, map it to a 'Date & Time' field type so that you can use special 'Date' rules to filter based on this date.

Follow these steps to map your field to the 'Date & Time' type:

1

Map the field

Go to Setup > Imports > [Added import] > Edit mapping. Locate your internal field with the date in it.

2

Edit the field

Click on the Edit button for that field.

3

Set type to Date & Time

In the pop up, at the Type field, select 'Date & Time'.

4

Save and import

Click on Save and import. There will be a new Custom date format dropdown next to the Edit field.

5

Choose or specify date format

Click on the Custom date format dropdown. Choose a default date format, or choose to specify a custom date format.

Date formats

Date in your import	Date format to choose in Channable
2017-10-19T15:03:23	ISO 8601
2017-10-19T15:03:23Z 2017-10-19T15:03:23+02:00	ISO 8601 TZ
Thu, 19 Oct 2017 15:03:23 +0200	RFC 2822
2017-10-19	Year-month-day
19-10-2017	Day-month-year
10-19-2017	Month-day-year

or use a custom format:

Custom formats

Custom formats specify the format of a date.

Date in your import	Custom date
25-07-2017 11:53	%d-%m-%Y %H:%M
25-07-2017 11:53:39	%d-%m-%Y %H:%M:%S
25-07-2015T11:53	%d-%m-%YT%H:%M

The date format is defined by a string containing two types of characters:

• Static text: Characters that appear literally in the output (e.g., /, -, space)

• Specifiers: Variable date parts that start with a percentage symbol (e.g., %m for the month number)

Note: Format specifiers expect numbers to have their full format (i.e. 05 instead of 5) by default. To use the shortened version, use %- followed by the specifier (e.g. %-d).

Format specifiers	Description
%Y	The year
%y	The year of the century, so two digits
%m	The month of the year (as a number)
%B	The name of the month of the year (January, February, etc.)
%b	The short name of the month year (Jan, Feb, etc.)
%V	The week of the year (as a number 1-53)
%d	The day of the month
%A	The name of the day of the week (Monday, Tuesday, etc.)
%a	The short name of the day of the week (Mon, Tue, etc.)
%p	The day-half of the day (so AM or PM)
%H	The hour of the day (so from 0 to 23, inclusive)
%I	The hour of the day-half (so from 1 to 12, inclusive)
%M	The minute of the hour
%S	The second of the minute
%Q	Optional period and fraction part of the second. To specify fractional seconds, combine this with %S, i.e. use %S%Q
%z	Timezone offset in the format ±HHMM
%Z	Timezone name, or offset in the format ±HHMM

Tip: To use a % in a string, use %%.