Dates are a critical component of your CRM data. They are responsible for helping our CRM systems create timelines and appropriately organize data.
Insycle matches and identifies data fields using multiple different formats. Additionally, Insycle allows you to reformat dates when using the Magical Import module.
Date Format Matching
Insycle attempts to match date value using multiple formats in the following order:
- Date time with timezone: 2018-07-19T23:25:45.671-0400
- Date time in UTC timezone: 2018-07-19T10:15:30Z
- YYYY-MM-DD HH:MM:SS
- Date (YYYY-MM-DD): 2018-07-19 or 2018/07/09
- 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 Blog Articles
- 5 Steps for CRM Data Standardization
- How to Create a Customer Data Management Plan
- Standardize State & Country Fields That Break HubSpot Salesforce Sync
Related Help Articles
- Module Overview: Transform Data
- Module Overview: Cleanse Data
- Module Overview: Magical Import
- Cleanse Data
- Explore Database Fields and Values
- Map Values From One Field to Another
- Convert Field Type From Free-Text to Picklist
- Import New Records or Update From CSV
- Format Names, Phone Numbers, Addresses
Additional Resources