How do I create a Date field?

To create an update a custom field with the type Date, follow the steps below:

a. Create a new custom field

1. Click Subscribers > Lists > Your List.
2. Click Settings.
3. Click Subscriber Fields.
4. Click Add new field.
5. Type the field name. 
6. Select Date as the Field Type.
7. Select dd/ΜΜ/yyyy at the Format Date.
8. Check the Hidden subscriber field if you do not want the field to appear on the sign-up forms.
9. Click Create.
   
   

b. Setup your file

1. Select the date column.
2. Right-click on the column and then select Format Cells.
3. From the categories, select Date.
   
   
   
   
4. Select Type dd/m/yyyy (sometimes it’s displayed as “14/03/2012”).
5. Select Locale (location): English (United Kingdom).
6. Save your file as type .xlsx (sometimes it’s displayed as Excel Workbook).

c. Import your file

When importing your file on your list, ensure you match the date column to the new field.