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.
Subtract Dates
I have created a saved search and i would like to subtract the Applying Transaction Date (bill payment) by transaction date (bill) to get the days. I've tried a couple variations but nothing seems to work right.
Any help would be appreciated
I tried these
Formula (Date)
{trandate}-{applyingtransaction.trandate}
{createdfrom.trandate}-{applyingtransaction.trandate}
0