How's everyone doing?
Can someone help me clarify the difference between the following set expression? The goal is to return last 7 days [DaySeqNum] between max([DaySeqNum]-7 and max(DaySeqNum)
[DaySeqNum]= {">$(=max([DaySeqNum])-7)<=$(=max([DaySeqNum]))" }
Correct Result (20110125 to 20110131 assuming max([DaySeqNum])=20110131)
[DaySeqNum]= {">=$(=max([DaySeqNum])-7)<=$(=max([DaySeqNum]))" }
Incorrect Result (20110124 to 20110131 assuming max([DaySeqNum])=20110131)
The only different is >= versus > right after the first quote. Why wouldn't >= work? Shouldn't it return [DaySeqNum]-7?
If there are qvw examples of set expressions filtering on date ranges, please forward them if possible.
Your help is much appreciated!
