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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Calculating days since a date in a saved search
I am trying to determine how many days have elapsed since an order was placed.
I am using a Formula (numeric) field to do the calculation, and setting the formula to this: {today}-{trandate}
I expected to get a nice round integer, like 3, but instead I get 3.55820601851851851851851851851851851852
I can clearly round my results down to solve the problem. Is that the cleanest way to solve the problem? I'm looking for a durable solution that would solve for daylight savings time changes, etc.
0