For the complete documentation index, see llms.txt. This page is also available as Markdown.
Use a date field in the import mapping
Map date fields correctly and use supported date formats.
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] > Mapping. Locate your internal field with the date in it.
2
Edit the field
Click Edit.
3
Set type to Date & Time
In the pop up, at the Type field, select 'Date & Time'.
4
Save and import
Click 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
