Please Help Crystal Novice with Formula!

[branch861]

I presently have a crosstab that displays the months. But next to each month I would like for the next month to appear as well. Example of what I would like to see:

Jan-03 Feb-03
Feb-03 Mar-03
Mar-03 Apr-03
Apr-03 May-03
etc. Does this make sense? Please help!

Thanks so much!
J.Branch

 

[synapsevampire]

You don't really need a crosstab, just place the date field alongside a next month formula.

The formula for the next month is:

dateadd("m", 1,{Orders.Order Date})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[branch861]

I figured out the solution.

Thanks for being here though!