Upcoming Enhancements to DATETIME Field Queries

Upcoming Enhancements to DATETIME Field Queries

  

This notice is to inform you of upcoming changes to the SuiteScript 2.0 Record.getValue(options) and format.parse(options) methods used to return string values for DATETIME fields. These enhancements will be released in production and sandbox accounts with the upgrade to 2018.2. They will increase the consistency and reliability of DATETIME field queries. Currently, the Record.getValue(options) method returns a string for DATETIME fields, as shown in the following example:                            myString = ‘Date is: ‘ + record.getValue({fieldId: ‘datechanged’}); // “Date is: 1/20/2018 12:34 am”                      The format.parse(options) method for DATETIME fields silently fails when the input string does not include seconds. After your account is upgraded to 2018.2: [LIST] [*]The Record.getValue(options) method will return a JavaScript Date object. [*]The Format.parse(options) method for DATETIME will no longer fail when the input string does not include seconds. [/LIST]