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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Relative Dates in Search Results Columns
I have a handful of items which I want to see my "available" amount, "backordered" amount, the # I sold this week last year, and the # I sold this month last year all on one search.
I know I can create the columns using formula fields and manually set the dates I'm looking for, but I'm hoping to make this dynamic instead of locking in the dates.
Here's what I currently have for those two results columns:
case when {trandate} between to_date('03/01/2011', 'MM/DD/YYYY') and to_date('03/31/2011', 'MM/DD/YYYY') then {quantity} else 0 endIs there a way I can set this up with "This week last year" and "This month last year" or even something like "today"-365 to "today" -358. If anyone can point me in the right direction I'd definitely appreciate it.
0