Date Calculations on parameters..


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}='DD\MM\YYYY'

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? 




rubamushtaq's picture
Joined: Nov 13 2012 - 8:37pm
Last seen: 9 years 11 months ago

0 Answers:

No answers yet