formula for forecasting weeks

[sbamforth]

Hi All,

i'm a bit of a newb at crystal reports and have hit the following problem :

im trying to create a formula in a salesperson forecast report to show revenue distributed over the next 4/5 weeks in 1 week blocks from days monday - sunday. I know how to do this when using fixed dates ie 1st - 31st but have never tried using the day names and am having little - make that no - success.

thanks for any suggestions

 

[synapsevampire]

Create a formula to group on:

DatePart("ww",{table.date},2)

Now just select the appropriate dates in the record selection formula:

{table.date} >= currentdate
and
{table.date} <= currentdate+28 (or however many days you want).

-k