Avoiding Event Date/Time Formatting Errors
When using the CSV Import Assistant to work with event records, you must format the dates and time values correctly.
For both the Date and End Date fields, the values you enter should match the NetSuite formatting preferences of the person doing the import, as set at Home > Set Preferences, under the Formatting heading. The two relevant fields are Date Format and Time Format.
For example, suppose you want to enter a date and time in the Date field, and your NetSuite preferences are as follows:
-
Date Format is MM/DD/YYYY.
-
Time Format is hh:mm:ss AM/PM.
In your CSV file, any date and time values you include should use these formats. The date and time values should be separated by one space. For example: 12/16/2013 12:00:00 PM.
If you are using Microsoft® Excel to create your CSV file, you should right-click the column and choose Format Cells to explicitly select a format that matches the Date Format (and if applicable, the Time Format) specified in NetSuite. Do not apply date formatting to any empty cells.
For more details on how to successfully map the Date and End Date fields for a CSV import, see Event Date and Time Fields.