Date Calculations on parameters..

[rubamushtaq]

Hi,

I need to design the report which shows records on parameter basis.

I have following requirements along with parameters.

1 $P{Report_Type}=Half Yearly or Monthly.

2.$P{ Report_ Date}='DDMMYYYY'

Now If I have to get monthly record I need to find the $P{Report_Date} month and then print the records from the 1st day of that month.

And when I have to get half yeraly report it will bechecked wheather $P{Report_Date} lies between dates(01-01-2012 to 30-06-2012) then print record  from (01-01-2012 till 30-06-2012)

or when $P{Report_Date}  lies between dates (01-07-2012 to 31-12-2012) then print records from dates (01-07-2012 to 31-12-2012). Please let me know how can I do this in sql query? 

 

Ruba