When importing values to a Date Picker property using the basic (default) import, the date values must be formatted as mm/dd/yyyy to be passed properly into HubSpot. For example, 10/08/2014 represents October 8, 2014.
However, you can use the advanced options menu in the import process to choose a format for date properties that you have on your import (Note: all date properties in a single CSV file must be in the same format).
- After you begin your import and have selected your CSV file, click Upload to move onto the Import details screen.
- Within the Advanced Options section, locate Default format for date properties and choose the desired date format from the dropdown menu for this particular import.
- Using the October 8, 2014 example noted above, your options are:
- mm/dd/yyyy (10/08/2014)
- dd/mm/yyyy (08/10/2014)
- yyyy-mm-dd (2014-10-08)
Please note: At this time, it is not possible to import time stamps into a Date Picker property.