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!
Syntax for days until a future date function in Analytics dataset
I need to create a function in an Suite Analytics dataset that will calculate the days between TODAY and a future date for a dashboard inventory availability tracker. The future date is a transaction field. Simple functions like {Current_Date}-{Future_Date} dont work & looking for options took me on a circular journey through CASE statements, CAST statements where the data types seemed to clash & the function wouldnt verify. I have limited SQL/coding knowledge so I'm hoping gurus are better than AI :)