Skip to main content

Mapping Date Fields




  • Gamma Technologies

    I'm looking to map a NetSuite Date to Salesforce Date. The help above recommends using YYYY-MM-DD, but that is NOT an option available in the picklist. Only the YYY-MM-DDTHH:mm:ssZ is available (and I get failure due to date format if I select it).

    Comment actions Permalink
  • Crystal He

    Had the same issue as Gamma

    Comment actions Permalink
  • Courtney Jordan

    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.

    Comment actions Permalink
  • 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

    Comment actions Permalink
  • PSA Admin

    Information would seem to be completely inaccurate. The format must correspond to the format set in NetSuite Setup/Company/General Preferences. One can just copy and paste those format strings for date and/or time, for example: {{dateFormat "MM/DD/YYYY HH:mm:ss" mySFdate}} on the source record side of the field map.

    Comment actions Permalink

Please sign in to leave a comment.