date for week,month,Quater

[jagadish]

i need to display data based on the date range give by user...
if the give date range is greater then 12 weeks,
ExR>12 then ....data should display for Q1 , Q2 like that , can any one help how can i get the data in that formate...
After that if DR>4 weeks...it should give the output for each month...
...So help me ASAP

[jkoopmann]

please supply table structure with columns and data type.
along with sample input and output.
also, what database are you on?

[jagadish]

Thanks for u r reply...

Table Struct is this for one table

Name Null? Type
----------- -------- -----
BEG_DT NOT NULL DATE
END_DT NOT NULL DATE

Table Struct is this for another table

Name Null? Type
----------- -------- -----
SBEG_DT NOT NULL DATE
SEND_DT NOT NULL DATE
Amount Number

User input will be any date range like this...01-jan-2001 to 31-jan-2001
Begin date is 01-jan-2001
End date is 31-jan-2001

I want to check this in both the tables and i want to display the data based on the one of weeks..if the weeks are >12 then the data should display for Quaterly..if data range is >4 weeks then for monthly...
so help me on this ASAP

Thanks

[jkoopmann]

you still havent' given us the database you are using.

sounds like this requires a procedure since you are trying actually displaying different summations based on the input from the user.