Skip to main content

Map date fields

Tom Santiago
  • Updated

When mapping date fields, an export date format is required. In both NetSuite and Salesforce, there are two different types of date fields:

  1. Date field (Displays the month, day, and year)
  2. 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.

DateFormat.jpg

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

Related articles

Comments

2 comments

Date Votes
  • Info Streefland

    Doe anybody know how to do calculations with dates?

    For example subtract 1 day from 2019-05-01

    tested {{subtract 2019-05-01 00-00-01}} but that gives NaN

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Info Streefland, PSA Admin, Gamma Technologies - Thank you so much for letting us know about these inaccuracies. We will get the article updated asap - in the meantime, we've got a robust Handlebars Library which enable you to use built-in functions like dateAdd.

    0

Please sign in to leave a comment.