Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Creating a custom filed that displays the current date
What formula do I use to display (in a custom field) the current date + 14 days? So if today is 5-1-08 I want the field to display 5-15-08
I then want another custom field to look at this date and when past the 15th to display a value of -1 and cont down each day that passes…..-1, -2, -3, etc.
Ultimately here is how I want this to work:
Custentity1 when a value > 1 is present then Custentity2 displays that days date pluss 14 days. Then custentity3 will have a value of 0 till custentity2 passes the 14 day mark….then custentity3 will display -1….-2….-3 and continue to count down.
0