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