This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I am trying to populate a DATETIMETZ sublist column in a suietlet, but when trying to set the value using both a String or Date, I am getting and INVALID_FLD_VALUE error. Has anyone had success with this?

what does your code setting the field look like

```var myDate = supportcaseSearchResults[i].getValue(supportcaseSearchObj.columns[9]);
                                var parsedDate = format.parse({
                                    value: myDate,
                                    type: format.Type.DATETIME
                                });
                                sublist.setSublistValue({
                                    id: 'custpage_sublist_message_date',
                                    line: lineNum,
                                    value: parsedDate
                                });```

and after its parsed its: 2018-09-27T13:40:00.000Z

I realize the time is wrong in the parsed value, but thats ok

your datetimetz wants seconds in the string

```var dateString = supportcaseSearchResults[i].getValue(supportcaseSearchObj.columns[9]);
    var parsedDate = format.parse({
      value: dateString,
      type: format.Type.DATETIME
    });
    var formattedDate = format.format({
      value: parsedDate,
      type: format.Type.DATETIMETZ
    });
    sublist.setSublistValue({
      id: "custpage_sublist_message_date",
      line: lineNum,
      value: formattedDate
    });```

I was hoping the sublist would properly sort the data if the column type was date/time instead of a string, but looks like it doesn't. Either way though, thanks for helping me get this working