Jump to content
Changes to the Jaspersoft community edition download ×


Recommended Posts


I am using Jaspersoft 6.16. I have a field STARTDATE, retrieving data from a table in the database. The field type in the database is date. Now when I am previewing the report it shows data as (MM/DD/YYYY, TIMESTAMP). But i want it as (DD/MM/YYYY) only. 

Please suggest an easy and step-by-step solution. Thanks

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

There are multiple ways to do that date formatting.

1. Use the "Pattern" field on the "Text Field" tab.  The ... can help with many different formats


2. Create an expression with the formatting built-in using SimpleDateFormat()

new SimpleDateFormat( "dd/MM/yyyy").format($F{MySqlDate})

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...