Wednesday only data 1

[wld1957]

I need help in having the report automatically select the information based only on each Wednesday for the current week (Monday - Friday). Currently I have a Date parameter that is used to select each Wednesday. It would be easier than selecting a date each time the report is ran.
In the selection criteria I use:
{cpmain.courtdate} = {?SALE DATE}

I have tried dayofweek, crWednesday in a formula but have not been able to get the report to work with this.

Any help would be appreciated. Thanks in advance.

 

[CR85user]

Just to clarify:

You want to only see the relevant information for Wednesday of the current week?

If you run the report on Monday the 1st then you want info from Wednesday the 3rd only?

If you run the report on Friday the 5th then you want info from Wednesday the 3rd only?

What happens if you run the report on Saturday or Sunday? Is it again only to pull results from the Wednesday of the current week?

If so try the following:

{cpmain.courtdate} =
if dayofweek(today) = 1 then today-4 else
if dayofweek(today) < 4 then today+(4-dayofweek(today)) else
if dayofweek(today) > 4 then today-(dayofweek(today)-4) else
today

If you base your weeks differently then you must adjust the formula.

There are probably 100 more elegant ways to do this - but you can at least understand the principle behind the above.

'J

CR8.5 / CRXI - Discovering the impossible

 

[wld1957]

Thanks, that did work.

 

[lbass]

You should be able to use:

{cpmain.courtdate} = currentdate-dayofweek(currentdate)+4

If you wanted the report to go back to the previous Wednesday if the currentdate was Sunday, then you could use:

{cpmain.courtdate} = currentdate-dayofweek(currentdate,crMonday) + 3

-LB