Having Trouble setting a date field I keep getting...
# suitescriptm
Mark Needham
05/13/2019, 7:31 PMHaving Trouble setting a date field I keep getting the error Invalid date value (must be M/D/YYYY)
using this code I thought I would fix this
var rawdate = new Date(newdata[0].values.trandate);
var newtrandate = format.format ({
value : rawdate,
type: format.Type.DATE
});
What am I missing here
b
battk
05/13/2019, 7:33 PMwhat value is in the rawdate
battk
05/13/2019, 7:34 PMin general, you use the format module to parse the date string into a Date
battk
05/13/2019, 7:34 PMand then use the Date itself to set the field
m
Mark Needham
05/13/2019, 7:34 PMits a date string
Mark Needham
05/13/2019, 7:35 PMfrom my reduce array
b
battk
05/13/2019, 7:35 PMas in which Date did new Date interpret the string as
battk
05/13/2019, 7:36 PMyou can log its value using rawdate,getTime()
battk
05/13/2019, 7:36 PMor rawdate.toISOString()
m
mkachline
05/13/2019, 7:37 PMIf you have the option, I would recommend dropping a copy of moment.js into your SuiteScripts file cabinet, then using that for date/datetime manipulation. I've found it well worth the quick hassle of dropping the library in.
m
Mark Needham
05/13/2019, 7:39 PMthanks I will try that
Mark Needham
05/13/2019, 7:40 PMbtw here is what I get for the raw date and then formatted date log
raw date Debug "2018-06-26T070000.000Z"
newtrandate 6/26/2018
m
mkachline
05/13/2019, 7:41 PMA snippet from my UE script which uses moment.. Note that moment.js lives in the FileCabinet under "/SuiteScripts/Libraries/moment.js"
define(['N/record', 'N/search', 'N/url', 'N/ui/serverWidget', '/SuiteScripts/Libraries/moment'],
function(record, search, url, serverWidget, moment) {
b
battk
05/13/2019, 7:41 PMthat looks like it interpreted the date correctly
battk
05/13/2019, 7:41 PMhow are you setting the Date field
m
Mark Needham
05/13/2019, 7:41 PMcco.setCurrentSublistValue({
sublistId: 'line',
fieldId: 'custcol_co_date_sold',
value: newtrandate
});
b
battk
05/13/2019, 7:42 PMsetValue for Date fields uses a Date
battk
05/13/2019, 7:42 PMsetText for Date fields uses a string
battk
05/13/2019, 7:44 PMi recommend using setValue with a Date
75 Views