Formatting Error When Setting Date Field

Hi, when I’m writing a server side script, I seem to always have trouble setting new Date() on a field. The error I get says the format is wrong:

{“type”:”error.SuiteScriptError”,”name”:”INVALID_FLD_VALUE”,”message”:”Invalid date value (must be M/D/YYYY)”,”stack”:

But I’m formatting it using the format API and when I log my variable it’s ‘3/18/2020’, seemingly the correct format. The odd thing is I only get this error when using record.setValue(). When I do record.submitFields(), it’s fine.

Any suggestions on how to fix this?

Beginner Asked on March 18, 2020 in SuiteCloud.
Add Comment
2 Answer(s)

Use setValue with a Date object as the value.
Use setText with a N/format module formatted string as the text.

Intermediate Answered on March 18, 2020.

That worked. Thanks!

on March 18, 2020.
Add Comment

I tried this code, but it doesn’t work, still “INVALID_FLD_VALUE”. What should be the problem?

var startDate = format.format({type: format.Type.DATE, value: new Date(values.custrecord_startdate)}) ;

var endDate = format.format({type: format.Type.DATE, value: new Date(values.custrecord_bits_enddate)});

Rookie Answered on February 4, 2021.

Does your date object look correct when you log it?

on February 4, 2021.

Yup its correct. I found the solution. Need to convert the field  into a date field. I didn’t have to use format

newRecord.setValue(cfg.START_DATE, new Date(values.startdate));

on February 4, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor