filter problem

Hi Friends,

I have a week object in my Universe. this is derived from a table(Column is Week_End_Date). This column contains the data like
2003-09-03
2003-09-24
2003-10-01
2003-10-15
2003-10-22
2004-02-04
2004-02-11
2004-03-17
2004-03-31
2004-04-14
2004-04-21
2004-05-05
2004-06-23
2004-07-07
2004-07-14
2004-08-04 …
I formatted this Week Object in Universe with(mm/dd)i.e 07/14, 07/07, 06/30…

I want a filter in report for previous 25 weeks(previous 28 weeks from current week, here current week is 07/14) the out put data should be like this
07/14
07/07
06/23
05/05…upto previous 28 weeks

How do i do this in Report . I want this at report level
Could anyone please help me on this issue.

Regards, Ann


amreddy2k (BOB member since 2004-07-15)

What about:
=ABS(DaysBetween(,)) >= (25*7)

You can remove the sign if you have your date objects in the right order, but shouldn’t have to worry about that unless you have “future” data in the report.


digpen :us: (BOB member since 2002-08-15)

Hi

Thanks for your quick response

I have tried with your code(=sign(DaysBetween(CurrentDate(),))>= (257) ) but it’s giving the error “Incorrect Data Type” at 257.
could you please give me the detail statement about my issue. remember that my week object is mm/dd format.

any help would be greatly appreciated
Regards, Arr


amreddy2k (BOB member since 2004-07-15)

Sorry… that shouldn’t read SIGN, it should read ABS. I was writing some other code at the same time and kinda crossed some wires.


digpen :us: (BOB member since 2002-08-15)

Thanks again for your quick response

Here is my current data,
Week S(Count) D(Count)
9/3 1 0
9/24 1 0
10/1 1 0
10/15 1 0
10/22 1 0
2/4 2 0
2/11 2 0
3/17 4 0
3/31 1 1
4/14 2 0
4/21 2 0
5/5 2 0
6/23 2 0
6/30 5 1
7/7 56 7
7/14 3 0
8/4 1 0

If i use your query its giving

1.0 82 7
0 9 9

i guess its not giving the previous weeks or rows data.

Regards, Arr


amreddy2k (BOB member since 2004-07-15)