how to get dates of specific days??

[LouiseR]

How do I find out the date of one week past on Monday in Crystal reports? I need to be able to run a weekly report on any day of the following week, so I am trying to set up a range- start date (Monday of previous week) and end date (Friday of previous week) to test my data against.

I hope I explained this well enough.

Louise.

 

[lbass]

To select dates in the previous Monday to Friday, try:

{table.date} in minimum(LastFullWeek)+1 to maximum(LastFullWeek)-1

-LB

 

[LouiseR]

Thanks a million.