tayyebkhan Posted June 23, 2022 Share Posted June 23, 2022 Hi,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 More sharing options...
jgust Posted June 23, 2022 Share Posted June 23, 2022 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now