Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.