How Datetime Field Types Are Imported

All values to be imported to the Datetime field type use the same format as the user's time zone, and the date or time formatting settings.

Microsoft SQL Server changes the date format if it recognizes an incorrect date format. Each date must use the format YYYY-MM-DD, where:

• YYYY is the year (0001-9999)
• MM is the month (01-12)
• DD is the day of month (01-31)

When storing the time in a Datetime field type, the Import Data Wizard uses the user's time zone setting to convert the time to the UTC format. To display the time in a Datetime field type, the user's time zone setting is used. Set your time zone setting by clicking Options on the File tab.

The Import Data Wizard may not handle the date correctly if the date format in your source file is MM/DD/YYYY and you want the output date format to be DD/MM/YYYY.

Date Transformations

Apply these transformations manually only on fields with correctly formatted dates in a data map A file that contains information about how data from a source system corresponds to data in Microsoft Dynamics CRM.. You cannot apply these changes using the Import Data Wizard.

More information: Data Map Schema Reference

• Add to Date. This adds a specified number of days, months, and years to a date.
• Add to Current Date. This adds a specified number of days, months, and years to the current date, and sets the time. This transformation is useful when importing sample data.

  Specify the day offset in the range of -1 to 6, rather than 1 to 8.

• Advanced Add to Current Date. This adds a specified number of days, months, and years to the current date. Specify whether offsets are relative to the current date or to absolute values.

Suggested Preparation in Your Source Files

To avoid import errors, verify that all date values are in the correct format before starting the Import Data Wizard.