Data fetch from the database in JRXML

[pallavig026]

Hi,

I want to fetch the date from the database and then need to manipulate on that date to display the due date in the jasper report.

Table name is: ACCOUNTINGLOCATION

Column name: CURRENTACCOUNTINGDATE  (dd//mm//yyyy time)

currently im using below code

declared CURRENTACCOUNTINGDATE as a field,

and <queryString> <![CDATA[select CurrentAccountingDate from AccountingLocation]]> </queryString>

and used <textFieldExpression><![CDATA[EDATE(DATE(YEAR($F{CURRENTACCOUNTINGDATE}), MONTH($F{CURRENTACCOUNTINGDATE}), 14), 1)]]></textFieldExpression>

But in my report i alredy have a <queryString>. So is there any other way i can fetch the date from databsae?