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|
|25-07-2017 11:53||%d-%m-%Y %H:%M|
|25-07-2017 11:53:39||%d-%m-%Y %H:%M:%S|
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: