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.
Date Calculation
Hi,
Let's say I have a custom record with custom fields:
Transaction Number, Sale Date and Total Sales.
An example of record entries would be:
123 12/02/09 $150.00
124 12/02/09 $40.00
I'm trying to create a report that gives me last week's sales and yesterday sales and I'm hoping to achieve this with just one saved search.
The criteria that I used is Sale Date is within last week, this gives me last week's sales easily.
For yesterday's sales, I'm trying to use a formula (numeric) field.
This is where I'm lost. I'm trying to use a formula something along the line of this:
CASE WHEN( TRUNC ({today}-1) = TRUNC ({custrecordstoretranssalestartdate})) THEN {custrecordstoretransamountincgst} END
0