RE: Setting up a custom entity: Target date minus 16 weeks


We give our customers a contract readiness date {custentity1}. In order to meet this date we need to order components 18 weeks before the readiness date.

My plan is to create a custom entity that calculates ({custentity1}) minus 18 weeks and returns the date I need to order by.

Can someone help me with the syntax to use to do this calculation?


Thanks a lot!


Soloflex Rookie Asked on September 25, 2019 in Projects.
Add Comment
1 Answers
Best answer

Not entirely clear from your description, but I assume you mean a custom entity field? Also, if you count the number of days rather than weeks it simplifies the formula.

This is pretty straight forward with a workflow – you can set the formula to:

{today} – 126

NetSuite is able to calculate a date using (date value +/- integer). Run the workflow on record creation and set the field value of your custom field.



Beginner Answered on September 25, 2019.

Thanks a lot Alex. This works!


If I can be greedy, can you tell me how to remove the clock timestamp from the result?


Appreciate the help.


on September 25, 2019.

I didn’t have the time when I tested in my own environment – make sure your field type is set to ‘Date’ rather than ‘Date/Time’

on September 25, 2019.

In the entity? I’m using free form text.

When I switch to date it tells me: Invalid date value (must be DD-Mon-YYYY)



on September 25, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.