Importing a "Date"-field
If you have an import in Channable that contains a field with a date in it, you can map it to a "Date & Time" type so that you can use special "Date"-rules to filter based on this date. You need to map your field to the type: "Date & Time" in Setup > Edit mapping, as shown in the image below (step 1):
As soon as you've selected the Date & time type, you have to specify the format of the dates you have in your import. You can specify the format by clicking on the Date format button next to "Date & time" (step 2). You will see a drop-down and then have the option to choose different default date formats or, you can choose to specify a custom date format.
Which "date format" do I choose?
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, you can read more about this syntax on this page:
https://docs.python.org/3/library/time.html#time.strftime