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!
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.