How to Map Dates and Times in Your Import Using Import2

Published 28 September 2018

Description

Ensure you are importing the correct date and timestamps while performing a CSV import. Import2 provides a comprehensive list of date/time formats to choose from, to match the data contained in your CSV file.

1. Open your CSV file of data to be imported

2. Check that any columns with dates and/or timestamps are formatted the same throughout the entire column

3. When setting up your import field mappings, select the format option that matches the format of your CSV file data

Business Data Glossary
We know that talking about data could be confusing. Here is a list of terms for you to get up to speed. Learn more
The Complete Introduction to CSV
A straightforward and practical exploration of all things CSV, from how to create and open files, converting CSV from other formats and troubleshooting common issues. Learn more
Import your data into any business App
Take your data from CSV file to upload into your apps. Or, opt to take data directly from one app and copy it into another. Learn more