Date Formats for Import CSV

 

Dates are a critical component of your CRM data. They are responsible for helping our CRM systems create timelines and appropriately organize data.

Insycle's Magical Import module matches and identifies data fields using a variety of formats, and allows you to reformat dates before the data is imported into your CRM.

Date Format Matching

Insycle attempts to match date values using multiple formats in the following order:

  1. Date time with timezone: 2018-07-19T23:25:45.671-0400
  2. Date time in UTC timezone: 2018-07-19T10:15:30Z 
  3. YYYY-MM-DD HH:MM:SS
  4. Date (YYYY-MM-DD): 2018-07-19 or 2018/07/09
  5. Date (M-D-YYYY): 07-19-2018 or 7/19/2018

All the above formats work with and without the - or / symbols.

Select Date Format on Import

You can also select a specific Date Format when using the Magical Import module:

Additional Resources

Related Help Articles

Related Blog Articles