Hello everyone, Getting this error when I am setting value in date field Invalid date value (must be MM/DD/YYYY)

{"expectedReceiptDate":"11/17/2021","shipDate":"11/01/2021"}

Code :

var formatedShipDate = new Date(data.shipDate);
var formatedExpectedReceiptDate = new Date(data.expectedReceiptDate);

formatedShipDate = format.format({
    value: formatedShipDate,
    type: format.Type.DATE
})

formatedExpectedReceiptDate = format.format({
    value: formatedExpectedReceiptDate,
    type: format.Type.DATE
})

rec.setValue({
    fieldId: 'custrecord_bk_mcb_por_ship_date',
    value: formatedShipDate
});

rec.setValue({
    fieldId: 'custrecord_bk_mcb_por_expec_receipt_date',
    value: formatedExpectedReceiptDate
});

use setValue with a Date, use setText with a string

Tried it. But it didnt work it just left the fields empty without any error.

what did your attempt look like

poRequest.setText({                 fieldId: 'custrecord_bk_mcb_por_ship_date',                 value: formatedShipDate             });             poRequest.setText({                 fieldId: 'custrecord_bk_mcb_por_expec_receipt_date',                 value: formatedExpectedReceiptDate             });

Use it correctly: Record.setText

Thats what I did

read the doc

poRequest.setText() poRequest is the Record

what are the 3 parameters to setText?

Oh

if you were using typescript you probably would have avoiding this entire conversation

@stalbert I've actually been curious about this for some time, can you expound a bit on the benefits of TS vs JS (and downsides)?

I've expounded ad nauseum on this topic 🙂 Anyway, one of the biggest benefits especially relevant to us SuiteScripters is related to time waste. To run a script we have to take time to upload a script then time for some manual steps to actually execute the code. TypeScript can catch many errors before you even upload the code. That time savings alone is significant and accumulates.

🙂 Thanks, got it. And downsides?

Downside is you have a small bit of setup to do in most IDEs to tell it to automatically compile your TS files to JS behind the scenes.

Got it, thank you!

Also, once you start to enjoy typing there is a risk of wanting to type ALL THE THINGS! Typescript is forgiving and you don't have to have types for everything.