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"-field so that you can use special "Date"-rules to filter based on this date. To make use of these rules, you need to map your field to one of our "Date"-fields, as shown in the image below (step 1):
Note: Only the date fields "date", "end_date"and "start_date" will activate the date rule options. The other fields like "expiration_date" or "sale_price_effective_date" will not activate these date actions.
As soon as you've selected a date field you have to specify the format of the dates you have in your import. You can specify the format by clicking on the "+"-sign next to the "Date"-field (step 2). You 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