Anyone know why I get this error when I feed in ne...
# suitescripta
apaule
03/02/2020, 9:05 PMAnyone know why I get this error when I feed in new Date() as the value "{\"type\":\"error.SuiteScriptError\",\"name\":\"INVALID_FLD_VALUE\",\"message\":\"Invalid date value (must be M/D/YYYY)\"
b
battk
03/02/2020, 9:07 PMthat usually what happens when you dont pass in a Date as the value
battk
03/02/2020, 9:07 PMwhats the code you are using?
a
apaule
03/02/2020, 9:07 PMnewRec.setValue({
fieldId: fieldName,
value: new Date(value)
});
b
battk
03/02/2020, 9:08 PMand the value
a
apaule
03/02/2020, 9:08 PMOh I think value is a string is that the problem?
apaule
03/02/2020, 9:08 PM"startdate": "02/26/2020"
b
battk
03/02/2020, 9:08 PMif its not in iso-8601 format, its unlikely to work
battk
03/02/2020, 9:09 PMwhere is the value coming from?
a
apaule
03/02/2020, 9:09 PMa post body
b
battk
03/02/2020, 9:10 PMis it from a netsuite form and a date field?
a
apaule
03/02/2020, 9:11 PMno it's from postman
apaule
03/02/2020, 9:11 PMas raw JSON
b
battk
03/02/2020, 9:11 PMif possible, use iso-8601 format for the string
a
apaule
03/02/2020, 9:12 PMokay I'll look into that format
b
battk
03/02/2020, 9:13 PMits the format you would get using
Copy code
new Date().toISOString()a
apaule
03/02/2020, 9:20 PMerhm now I get this "message": "org.mozilla.javascript.EcmaError: RangeError: Date is invalid.
b
battk
03/02/2020, 9:26 PMwhats the string used for the value
a
apaule
03/02/2020, 9:31 PM"2020-03-02"
b
battk
03/02/2020, 9:34 PMuse the full format (include date and time)
battk
03/02/2020, 9:34 PMYYYY-MM-DDTHH:mm:ss.sssZa
apaule
03/02/2020, 9:35 PMyeah i tried that as the string and got this error: \"The field startdate contained more than the maximum number ( 10 ) of characters allowed.
b
battk
03/02/2020, 9:36 PM Copy code
newRec.setValue({
fieldId: "startdate",
value: new Date("2020-03-02T21:36:03.591Z")
});a
apaule
03/02/2020, 9:37 PMyeah I get it to work in the debugger
apaule
03/02/2020, 9:37 PMbut it doesn't like this post function
apaule
03/02/2020, 9:45 PMOkay I'm an idiot it was some logic later in the loop trying to set the value again of startdate
apaule
03/02/2020, 9:45 PMit's working now 🙂 thanks
7 Views