Need help creating creating formula for dtae range...

[mattner]

I have to put some reports on Crystal Enterprise.

The first will be scheduled to run weekly on Monday morning to show all activity for the previoues week (Sunday to Saturday).

The second will be similar, except it will be scheduled to run on the first day of the month, showing all the activity for the previous month.

What kind of formulas can I put in the selection criteria to accomplish this?

 

[rhinok]

{table.activitydate} in LastFullWeek

{table.activitydate} in LastFullMonth

Hope this helps

 

[mattner]

Worked beautifully.

Now another silly question: How do I relect what date range the report is showing in the report header?

 

[goranm]

Hi !
Here is one exampel how you can show it:

'Period: ' + ToText(minimum(LastFullWeek)) + ' -- ' + ToText(maximum(LastFullWeek))

And for the month range just switch LastFullWeek with LastFullMonth.

/Goran

 

[mattner]

Thanks so much. I learned something else today!!!