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 a new 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-19 |
ISO 8601 |
2017-10-19 | Year-month-day |
19-10-2017 | Day-month-year |
10-19-2017 | Month-day-year |
Custom formats: | |
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 custom formats on the bottom of the table below are written using the "strftime" format.