Hi, I am using iReport 3.0.0 and JasperServer 3.0.0 with Postgresql 8.3. My report query is select rapiderp.findstartperiod($P{periodID}) , rapiderp.findendperiod($P!{periodID})::date as aging_run_date, ar.customerid as aging_customerid, cu.name as customers_name,cu.name_ch as name_chinese, cu.agentgroupid as customers_agentgroupid, ag.groupname, sum(case when ar.period_id<$P{periodID} then ar.amount else 0.00 end) as aging_openingbalance, sum(case when ar.period_id<=$P{periodID} then ar.amount else 0.00 end) as aging_closingbalance, sum(case when ar.period_id=$P{periodID} and ar.sourcetype='IN' and iv.invoice_balance is not null then iv.totalamount-coalesce( (select sum(rd.amount) from rapiderp.receiptdetails rd, rapiderp.receipts rr where rr.receiptid=rd.receiptid and rd.sourceidapplied=iv.invoiceno and rr.period_id<=$P{periodID}),0.00)::numeric else 0.00 end)........... IF the periodID is 152 ....it should result in the rapiderp.findendperiod($P{periodID}) as '2008-07-31'::date. But it always display as 2007-07-30 in the reports. or perodID=153 ..-> 2008-08-31 .....print out as "2008-08-30". Please assist .. Regards David