Formula to suppress everything except the next weeks data 1

[taltonm]

Hello,

I dont know if I am missing something here but I am stumped. I am trying to write a suppression formula that will suppress date values that are not in the next Business week. For Instance, If you have run the report on a monday, it should supress everything except next weeks data and the same would be true if you ran the report on Friday, you would get the same data. Calendar week or Business wekk. Does not matter to me. Any help would be appreciated!

M-

 

[lbass]

I would use a selection formula instead of suppression, like:

{table.date} in dateadd("ww",1,currentdate-dayofweek(currentdate)+1) to
dateadd("ww",1,currentdate-dayofweek(currentdate)+7)

-LB

 

[taltonm]

unfortunately, the way that the report is constructed, with several subreports, I am limited. I know it is much more efficient to run a selection rather than a suppression. any ideas how i can translate that into a suppression formula? thanks for your Input!

MT

 

[taltonm]

Got the Suppression done, I used your Formula into and If then els enad if the date appeared in the next week, it displayed True, I suppressed everything other than that and it gave me what I am looking for, thanks again lbass!