Formula for date ranges

[rebecca2006]

Hello,
Sorry I'm very new at Crystal... I am trying to write a report that groups employees' review dates, by current month, previous month and next month. Can somebody tell me how I can do this? Again sorry this is very new to me..

 

[BB45]

When you post here you need to tell us the version of crystal you are using and the database type.

That being said, this should work.

Create a fomula with the following:

If month(ReviewDate) = month(currentdate) then "Current Month"
else
If month(ReviewDate) = month(LastFullMonth) then "Previous Month"
else
If month(ReviewDate) = month(dateadd("m", 1, currentdate) then "Next Month"

Then group on the formula.

BB

 

[BB45]

Forgot a paren in the last line use this

If month(ReviewDate) = month(dateadd("m", 1, currentdate)) then "Next Month