Mike Casey
02/06/2025, 9:48 PMCeligo AI
02/06/2025, 9:48 PMAI generated answer (using internal Slack threads):When working with the REST API in NetSuite, the valid inputs for a date/time field are typically in the ISO 8601 format, which is
YYYY-MM-DDTHH:MM:SSZ
. For example, 2019-06-12T18:00:00Z
is a valid input.
However, it's important to note that the date/time format can be influenced by the user's locale settings in NetSuite. For example, in the US, the date format is typically MM/DD/YYYY
, while in the UK, it's DD/MM/YYYY
.
When you're setting a date/time field in a script, you can use a native JavaScript Date object. If you're getting the date/time from a JSON object, you might need to parse it first.
If you're getting an "Invalid Date" error, it could be due to a formatting issue. For example, if the date/time string includes milliseconds or is in a different format than expected, you might need to adjust it before setting the field.
In SuiteScript 2.0, you can use the format.format
function to format the date/time string.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
02/06/2025, 9:48 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830093622
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829949796
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827159822
Celigo AI
02/06/2025, 9:48 PM