Yearly query

[mortac8]

I need help on making a query that will report from a date range of (the current date - 12 months) to (the current date). I need the previous 12 months worth of data reported whenever the report is run.

Any ideas? Thanks alot!

 

[BobWard]

surely you can justbuild a pre defined condition doing a between on your calendar table using a systemdate (sysdate, getdate() ) etc depending what database you are reporting aginst.

 

[deepakveni]

Hi,
You can do it by first taking a sysdate and then checking the date in record wheather it is a year behind to sysdate or not. Populate only those records which are satisfying the condition. Sysdate you can select from any table by giving condition of rownum=1.

Hope this will help you,

With cheers,
Deepak Veni