Calculating Week

[KeertanaCR]

Hi All,

I need to create a report, which should run weekly.
Suppose when the report runs on each Sunday, i have to get the information from Last Monday to Sunday.

I can actually put prompts for start date and end date and it will get the info for that period. But instead ,How can i get the last week dates in crystal reports.

Thanks for your help

 

[paulmarr]

EASY - how about:

{db.datefield} in [CurrentDate - 7 to CurrentDate]

Cheers
paulmarr

 

[mocgp]

The functions LastFullWeek and Last7Days are also available for use.

 

[KeertanaCR]

Thank You Paulmarr, that worked.