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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Problem using "round()" in custom field
Hi all,
I have had a bit of a rumage in the forums and cannot seem to find an example that points out what I am doing wrong. Please point the way if there is a thread that deals with this.
I am trying to work out the length of stay for our members list. We record the date joined as well as the date resigned. Ideally it would be nice to have the result in the format "x years, y months, and z days"... but I will settle for a function that works
This returns a correct result (albeit with about 20 decimal points)
0