Jump to content
We've recently updated our Privacy Statement, available here ×

Jaspersoft Ad Hoc View - Filter only records where datetime after 5:00


laura.mays

Recommended Posts

I have a datetime field, i.e. May 10, 2020 10:41:41 PM.

I'd like a filter in my report that pulls only those records in which the time is > 5:00 PM. 

How do I do that? I could build a calculated field to filter on but none of the existing functions actually extract the timestamp from a datetime field (i.e. Time and Timestamp functions don't work because the field is not a string). 

Link to comment
Share on other sites

  • 3 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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...