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.
Saved Search Date Parameters - Accessing and Using in the Formula
I have created a saved search based on the transaction record. I have the following formula:
SUM(CASE WHEN {trandate} BETWEEN TO_DATE('1/1/1986','MM/DD/YYYY') AND trunc({today},'MM')-1 THEN {debitamount} ELSE 0 END) - SUM(CASE WHEN {trandate} BETWEEN TO_DATE('1/1/1986','MM/DD/YYYY') AND trunc({today},'MM')-1 THEN {creditamount} ELSE 0 END)
I use this to sum all transactions up through the last day of the prior month to give me a beginning balance.
I want to be able to substitute the ((trunc({today},'MM')-1)) and replace it with the "from" date from the date filter.
0