[jmessersmith Contributions: 0Level 1☆]

Code:
nlapiSubmitField(‘salesorder’, searchresults[i].getId(), ‘custbodytracking_delivery_date’, nlapiStringToDate(’01/01/2011′));
Is there a way to use nlapiSubmitField to change a datetime field? I’m getting UNEXPECTED_ERROR.

Is the only other option using record.setDateTimeValue?
This is a cached copy. Click here to see the original post.

[jmessersmith Contributions: 0Level 1☆]

Nevermind, it was all a formatting problem. should be in this format: mm/dd/yyyy hh:mm:ss am|pm (for example, ‘09/25/2013 06:00:01 am’).

---

david.smith replied on 08/18/2016, 09:23 AM: Careful because each user can set their preferences to a different date format. See the other comments below for using nlapiStringToDate.

[k_dunc Contributions: 0Level 1☆]

Just BTW, I think the issue probably was your use of nlapiStringToDate. It probably should have been nlapiDateToString.

[errol Contributions: 0Level 1☆]

k_dunc is right. Also, for datetime fields, you could use nlapiDateToString(new Date(), ‘datetimetz’); The datetimetz will format it to work with the datetime fields. If you leave that out, it will format for normal date fields.

[Author]

Posts