Insycle attempts to match date value using multiple format 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 


  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.

You can also select specific Date Format during import:

Did this answer your question?