RE: 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!
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.
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.
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’
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)
