Formula to calculate starting date as the previous Monday

[hsandwick]

Crystal Reports 9

If I run a report today, today could be a Wednesday or a Friday of a given week, I want to see all results from the Monday of the previous week onwards. Is there a quick formula for this, please?

Thanks so much,

Helen

 

[lbass]

Try:

{table.date} in currentdate-dayofweek(currentdate)-5 to currentdate

-LB

 

[goranm]

Hi !

Here is one way:
{table.date} >= minimum(LastFullWeek)+1

/Goran

 

[hsandwick]

Hello, lbass and goranm:

Both of your ideas worked beautifully - thank you so much!

Helen