SuiteScript format.format INVALID_FLD_VALUE

Question

How to format a 2024/01/29 09:26:00 am value with the N/format module. INVALID_FLD_VALUE is displayed when writing. You entered an invalid field value for the following fields: 01/29/2024 09:16:20 am: custrecord_quote_update_time; ID:

使用以下代码解决报错提示：format.format({

value: new Date() ,

type: format.Type.DATETIME,

timezone: format.Timezone.ASIA_HONG_KONG

});

如果创建时间时候上午，更新时间是下午 无法更新成下午时间；

Thank you.

Nayeem Rahman Shaik · Accepted Answer

Hi

To format the date and time value "2024/01/29 09:26:00 am" using the N/format module, you can use the following code:

var formattedDateTime = format.format({

    value: new Date('2024/01/29 09:26:00 am'),

    type: format.Type.DATETIME,

    timezone: format.Timezone.ASIA_HONG_KONG

});

This code will format the provided date and time value according to the specified format type (DATETIME) and timezone (Asia/Hong Kong). Please note that you may need to adjust the timezone value based on your specific requirements.

Regarding the issue you mentioned with the "custrecord_quote_update_time" field, if you are encountering an error message stating "INVALID_FLD_VALUE" and "You entered an invalid field value for the following fields," it is likely related to the specific field and record you are trying to update. You may need to ensure that the provided value is in the correct format and meets the requirements of the field you are updating.

If there are conflicts between the AM and PM times when updating the field, you may need to review the field's settings and any business logic or restrictions in place to determine the cause of the issue.

Hope it is helpful!

Francesca Nicole Mendoza-Oracle · Accepted Answer

Hi @oliver zheng,

I'm circling back to ensure you saw my previous communication. Should you require any additional support, please don't hesitate to contact us.