Setting up a custom entity: Target date minus 16 weeks

Hello!

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!

 

Rookie Asked on September 25, 2019 in Projects.
Add Comment
1 Answer(s)
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.