Import a date field
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:
- Go to Setup > Imports > [Added import] > Edit mapping.
- Locate your internal field with the date in it.
- Click on the Edit button
- In the pop up, at the Type field, select 'Date & Time'.
- Click on Save and import. There is Custom date format dropdown next to the Edit field.
- 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 %%.