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!
Date Range by Week in a Saved Search
Hello All,
I'm having a difficult time getting a saved search to display a time period for 5 weeks back from the start of a week. I filed Enhancement#88453 but I'm sure there is a way to do it with a CASE statement. Any help is appreciated.
Problem: Look at only sales orders from 5 weeks back by week. (not relative, or date to week, month or year)
Example:
Date 8/20/2012 through 8/26/2012 I only want to see data from 7/16/2012 to 7/22/2016 not a rolling period but a static week. Next week I would only see data from 7/23/2012 to 7/29/2012 and so on.
Any of the ranges or relative does not work because each day the date moves one day farther out.
0