khanma Posted September 4, 2020 Share Posted September 4, 2020 Hello Experts I am using Jasper Studio 6.6.0 to make some reports with PostgreSQL as a database. When I am making a report with the Date filed, for some reason it shows the year as 1/1/70 [Ex: 1/1/70 2:30 AM] for all entries. When we make an entry we just enter the start time and end time, however on the report it shows the date also as 1/1/70. Just wanted to check how we can make the changes to this field under “Expression Editor” to only show the time. Your kind support would be appreciated Regards Link to comment Share on other sites More sharing options...
Sad H Posted September 9, 2020 Share Posted September 9, 2020 try the solution below and if you want 1/1/70 this format remove h:mm a from format at the end. 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