I received this error "
```Invalid date value (mus...
# generala
Ali Mohamed
11/08/2021, 6:40 PMI received this error "
Copy code
Invalid date value (must be D/M/YYYY)c
CD
11/08/2021, 6:45 PMNot enough information. Also, the message is quite clear. Share your code. Best to post in #suitescript
a
Ali Mohamed
11/08/2021, 7:59 PM// Create a NetSuite record from request params
function _post(context) {
doValidation([context.recordtype], ['recordtype'], 'POST');
var rec = record.create({
type: context.recordtype,
isDynamic: true,
});
for (var fldName in context)
if (context.hasOwnProperty(fldName))
if (fldName !== 'recordtype') {
if (fldName === 'custrecord_az_payroll_sheet_date') {
rec.setValue(fldName, context[fldName])
}
rec.setValue(fldName, context[fldName])
}
var submitRec = rec.save({
enableSourcing: true,
ignoreMandatoryFields: true
});
var output = new Object();
output.submitRec = submitRec;
return output;
}
Ali Mohamed
11/08/2021, 7:59 PMabove this is my code
c
CD
11/08/2021, 8:04 PMOh, @battk will enjoy this
k
King Leung
11/08/2021, 8:49 PMCan you share the payload that errored out?
b
battk
11/08/2021, 8:52 PMwont really matter, the code given cant set date fields
battk
11/08/2021, 8:53 PMuse setValue with a Date to set a date or date/time field
battk
11/08/2021, 8:53 PMalternatively use setText with a string to set a date or date/time field
k
King Leung
11/08/2021, 9:37 PMReally? I use setValue() for setting date all the time... it just needs to be in the right format
b
battk
11/08/2021, 9:48 PMthe code given has values taken directly from the JSON from the request, JSON has no representation for a Date
💯 1
k
King Leung
11/08/2021, 10:09 PMWhile JSON doesn't specify how dates are represented, UTC is widely used... but in this case a string could've been sent... did I miss something?
b
battk
11/08/2021, 10:13 PMa string can't be used with setValue to set a date/time field, in fact no value that JSON supports can do so
battk
11/08/2021, 10:15 PMits why the actual json from the request doesnt matter, the code for the RESTlet needs to handle date fields differently
✅ 1
a
Ali Mohamed
11/09/2021, 7:28 AM@battk I try setValue with date object and same issue
// Create a NetSuite record from request params
function _post(context) {
doValidation([context.recordtype], ['recordtype'], 'POST');
var rec = record.create({
type: context.recordtype,
isDynamic: true,
});
for (var fldName in context)
if (context.hasOwnProperty(fldName))
if (fldName !== 'recordtype') {
if (fldName === 'custrecord_az_payroll_sheet_date') {
rec.setValue(fldName, new Date(context[fldName]))
}
rec.setValue(fldName, context[fldName])
}
var submitRec = rec.save({
enableSourcing: true,
ignoreMandatoryFields: true
});
var output = new Object();
output.submitRec = submitRec;
return output;
}
c
CD
11/09/2021, 7:32 AMThe 2nd setValue executes unconditionally
a
Ali Mohamed
11/09/2021, 7:37 AM@CD yes I get the issue, I used the below code
// Create a NetSuite record from request params
function _post(context) {
doValidation([context.recordtype], ['recordtype'], 'POST');
var rec = record.create({
type: context.recordtype,
isDynamic: true,
});
for (var fldName in context)
if (context.hasOwnProperty(fldName))
if (fldName !== 'recordtype') {
var fldType = rec.getField({
fieldId: fldName
})
if (fldType.type === 'date') {
rec.setValue(fldName, new Date(context[fldName]))
}
else {
rec.setValue(fldName, context[fldName])
}
}
var submitRec = rec.save({
enableSourcing: true,
ignoreMandatoryFields: true
});
var output = new Object();
output.submitRec = submitRec;
return output;
}
Ali Mohamed
11/09/2021, 7:38 AMbut if in JSON write "9/11/2021" it created record with "11/9/2021" it replace month and day position
b
battk
11/09/2021, 12:39 PMgo over how the Date constructor works, you are using the least safe method to create a Date
battk
11/09/2021, 12:41 PMi dont think the Date constructor is causing your particular issue, its more likely that you need to understand how Date Formats work in NetSuite.
a
Ali Mohamed
11/09/2021, 7:23 PMThanks all my friends, I did it
156 Views