Using a date field in the import mapping (V1)

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?

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