How to get a value date field from DB

[my.nguyen]

Hello,

 

i am newbee so please help with my stupid question!

Postgsql DB, field name: CreateDate (TimeStamp)

I created report in jasperSoft Studio have a fieldname CreateDate.

How can I set the value for the field CareteDate=2015 only in the report?

I tried in express Editor: Integer.valueOf(2015).equals($F{createdate}) : it's not working right :(

Please advise, Thank you.

MN

[reportdev]

do you want to filter out the report based on year 2015 ? 

or

do you want to populate 2015 in the report ? 

 

[my.nguyen]

Thank for review.

I want to see both. How can I do that?

Thank you.

MN

[Balraj]

If you want to display/fetch only YEAR from CreatedDate then:

In TextField Expression give it as: YEAR(CreatedDate), this will return you year from passed date.

To get only 2015, then new Integer(YEAR(CreatedDate))==2015.

To filter data, you can update the query to return data of 2015 year.

Best Regards,

JasperExplorer

 

[my.nguyen]

Wow ... That working perfect :)

Than you JasperExplore!

[Balraj]

Glad that it worked for you. Accept it as answer,It'll be helpful for others

Best Regards,

JasperExplorer