Rolling 12 months

[ADB1]

I am trying to get the oracle sql to enable me to calculate a rolling 12 months worth of data from a date.

i.e. Start_date BETWEEN 1/1/04 AND 1/1/05 ......but I want the dates to be dynamic.

Can this be done?

Thanks in advance,

Adam.

 

[nagornyi]

between _date and add_monthsp_date,12)

 

[ADB1]

I put the sql in and got the following error:

ORA-01008: not all variables bound

Thanks.

 

[nagornyi]

Of course you need to define the parameter before using it. How - depends on the sql client you are using.