Rolling 12 Month Values

[sharonma]

I need to create a rolling twelve month report.

I have started with the following:

month(currentdate)-12 =month({table.name} )

I realize this won't work because there are no negetive months.

 

[synapsevampire]

Use the dateadd function to add/subtract dates:

dateadd("m",-12,{table.date})

There are lots of examples of a rolling 12 month report here, check the Crystal other topics forum for Howard Hammerman's approach:

faq149-1220

-k