Program for getting the date month week and year for the corresponding perd

Hai all,

I have an urgent requiremnt

in select options :

date from to

week from to

month from to

year from to

date is taken from the D.B table say zidlecode

week month and year is taken from the correspondng factory calendar table

i have to generate a report that gives the cumulative set of dates for the week say for eg ( 47 to 51) where the week and year is mandatory.and then it has to evn show me for wht month say eg enter 8 in the month.

please write a complete program for this and u

WILL be definitely REWARDED!!!!!!!!!!!.

Thanks and regards,

Sanjeev