When mapping date fields, an export date format is required. In both NetSuite and Salesforce, there are two different types of date fields:
- Date field (Displays the month, day, and year)
- Date/Time field (Displays the month, day, year, and time of day)
See Format date and time in ISO8601 for a complete list of date formats.
Click the Date format drop-down menu on the import mapping Settings menu to select the correct format for your needs.
Use one of the following date formats to map date fields between Salesforce and NetSuite:
| Salesforce and NetSuite date field format | Export date format |
| Salesforce Date or Salesforce Date/Time fields to NetSuite Date fields | YYYY-MM-DD |
| Salesforce Date or Salesforce Date/Time fields to NetSuite Date/Time fields | YYYY-MM-DDTHH:mm:ssZ |
| NetSuite Date or NetSuite Date/Time to Salesforce Date fields | YYYY-MM-DD |
| NetSuite Date or Date/Time fields to Salesforce Date/Time fields | YYYY-MM-DDTHH:mm:ssZ |
Comments
Please sign in to leave a comment.