How to set date/time field in netsuite with suitescript

Question

var curRate = nlapiCreateRecord("customrecord_currency_exchange_rates",{recordmode: 'dynamic'});
        serverDt = "09/25/2013 06:00:01 am"
        var timezone = compConf.getFieldText('timezone');
        curRate.setDateTimeValue('custrecord_effective_date' ,serverDt ,timezone);


        nlapiSubmitRecord(curRate);

Hello I try to set custrecord_effective_date field which is a date/time type. But after the execution it gives an error below. How can I set this field?

thanks for help.

INVALID_FLD_VALUE You have entered an Invalid Field Value 09/25/2013 06:00:01 am for the following field: custrecord_effective_date

what kind of field is it `custrecord_effective_date`? – Rockstar Jul 20 '15 at 14:50 — Rockstar, Jul 20 '15 at 14:50
it is a kind of Date/Time field – Arif Karadag Jul 20 '15 at 14:59 — Arif Karadag, Jul 20 '15 at 14:59

score 9 · Answer 1 · answered Jun 11 '17 at 01:44

Although this is an old post and the original question is about SuiteScript 1.0, I came across this page looking for the same INVALID_FLD_VALUE error with the date/time field but in SuiteScript 2.0, and since the solution ended up being different I wanted to share it for future readers.

In SuiteScript 2.0, setting a date/time field simply requires a JavaScript date object. Below is an example within a before submit user event context.

context.newRecord.setValue({
    fieldId : 'custrecord_myfield',
    value : new Date()
});

score 5 · Answer 2 · answered Mar 14 '18 at 07:59

For setting Date/Time Field values using SuiteScript 2.O.

First Use 'N/format' module and 'N/Record' Module.
Create a normal Javascript Date Object.
Format the Date Object to DateTime Object.
And use Record.setValue() method for setting the datetime value.

Example:

     var d = new Date();
     var formattedDateString = format.format({
                        value: d,
                        type: format.Type.DATETIMETZ
                        });

   record.setValue('yourDateTimeFieldId',formattedDateString );

score 3 · Answer 3 · answered Aug 18 '21 at 23:34

For anyone that may be stuck with a SuiteScript 1.0 script trying to populate a date/time field and the existing solutions don't work for you, you can try using NetSuites nlapiDateToString method. Apparently the date/time field wants a string.

Example:

var record = nlapiCreateRecord('your record type');
record .setFieldValue('your date field id', nlapiDateToString(new Date(), 'datetimetz'));
nlapiSubmitRecord(record, false, true);

The SuiteScript 1.0 reference for more detail:

score 1 · Answer 4 · answered Jul 20 '15 at 18:05

1

Hi thanks for answers after posting the question i checked the Form of record type and when i checked for the field 'custrecord_effective_date' I noticed that the date format must be 'DD/MM/YYYY HH:MM:SS' so when i changed it worked.

answered Jul 20 '15 at 18:05

Arif Karadag

129
1
2
8

score 1 · Answer 5 · answered Oct 04 '16 at 18:47

If you look at the NetSuite WSDL file, you will find the dateTime declaration:

<xs:simpleType name="dateTime" id="dateTime">
<xs:documentation
    source="http://www.w3.org/TR/xmlschema-2/#dateTime"/>

Go to the URL and look at the source:

3.2.7 dateTime

[Definition:] dateTime values may be viewed as objects with integer-valued year, month, day, hour and minute properties, a decimal-valued second property, and a boolean timezoned property. Each such object also has one decimal-valued method or computed property, timeOnTimeline, whose value is always a decimal number; the values are dimensioned in seconds, the integer 0 is 0001-01-01T00:00:00 ...

So the format you are looking for is:

2013-09-25T06:00:01

I just pushed a dateTime to NetSuite and it worked.

Looks like this answer is about SuiteTalk. The question is about SuiteScript. — cja, Jan 13 '17 at 17:31

score 1 · Answer 6 · answered Jan 15 '20 at 09:25

1

Import N/format to your script and use one of the date format types:

DATE

DATETIME

DATETIMETZ

var parsedDate = format.parse({
   value: '23/12/2010',
   type: format.Type.DATE
});

answered Jan 15 '20 at 09:25

Skromak

490
6
12

score 0 · Answer 7 · answered Jul 20 '15 at 15:12

0

The code looks ok Are there any restrictions on the date field such that you can't set a date in the past? Also your serverDt is the same value as the Netsuite help. Did it copy cleanly? What happens if you cut that string and type it directly?

And finally are you sure you have a datetime field and not a date field. If I apply your code to a date field I get the same error.

answered Jul 20 '15 at 15:12

bknights

14,408
2
18
31

thanks for answer. I found the solution . But i have one more question about setting date fields too. How do you do that ? – Arif Karadag Jul 20 '15 at 18:06
Can you be please be specific @ArifKaradag – NetSuite Help Mar 14 '18 at 14:48

score 0 · Answer 8 · answered Jul 13 '17 at 10:08

Little addition on the existing ans. Error type -

type: "error.SuiteScriptError",
name: "INVALID_FLD_VALUE",
message: "You have entered an Invalid Field Value 2017-07-13T08:21:12.411Z for the following field: custrecord_lastrundate",

The value need to be set as a java script date() object. Even the simple same string of js date will throw error. If you are using moment then below code will work perfectly. Sample for adding next days.

var now = moment();
now.add(1,'days')
fetchRecord.setValue({
   fieldId : 'custrecord_lastrundate' ,
    value : new Date(now),
    ignoreFieldChange : true
});

score 0 · Answer 9 · answered Feb 17 '22 at 02:44

This is related and the other 2.0 answers are correct for Date/Time fields. However I was trying to set the incident time on the case record which is just the time field, and you have to do something like this:

let incidentTime = new Date(0, 0, 0, incidentDate.getHours(), incidentDate.getMinutes());

Notice - its still a Date object, but the Y, M, D values have to be zeroed for it to work.

Ahh Netsuite - you couldn't just do that behind the scenes yourself..

Please let me know if someone has a different solution.

How to set date/time field in netsuite with suitescript

9 Answers9