This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello NS Universe, Help needed with workflow formula - getting error message - *You have entered an Invalid Field Value 2022-04-04 00:00:00 for the following field": custcol_delivery_date*
I have created a workflow that takes the dispatch date at line level on SO, adds lead-time &amp; populates the delivery date... we do not deliver on the weekends so the formula on the workflow looks to avoid this however I am getting an error with my formula.
Formula is:
CASE WHEN TO_CHAR({line.custcol_dispatch_date}+{custbody_so.custrecord_dlt}, 'DY') = 'SAT' THEN ({line.custcol_dispatch_date} + {custbody_so.custrecord_dlt} + 2)
else case WHEN TO_CHAR({line.custcol_dispatch_date}+{custbody_so.custrecord_dlt}, 'DY') = 'SUN' THEN ({line.custcol_dispatch_date} + {custbody_so.custrecord_dlt} + 1)
ELSE ({line.custcol_dispatch_date} + {custbody_so.custrecord_dlt})
END END

The delivery date is a custom date field and this is giving an output of the date/time? Do I need to specify the format of what the output should be? If so, how do I do this? Timezone GMT

change the field type to datetime or format the formula result to date.

<@UUDB74AD9> can't change the field type to datetime, how do I change the formula result to date on the workflow? is that changing the formula?