[Date and Time Issue..]

I created report in jasper studio. Issue is my report need to run  example  10/1/2017 7:00:00 am to 10/2/2017 7:00:000 am means pull data today and next 24 hours data.

I failed to display with this time format..

How can i run the report with specifi dat and time format conditions in the report?

 

Any help ???

 

Thanks.

[Joing Error]

Thank you

[Joing Error]

I am trying to join two column in sql in jasper reports.

The  problem is one column has quotes like "group" and other one is just id.

These are the two UUID's  , nee to join to get the data.

I am unable to join these 2 columns.

Plrase help me.

 

Thanks.

 

[Date Conversion]

I am trying to create "Date" custom field in Jasper studio.

How do i caluclate date difference in sql query in jasper?

I tried this way, but its not working

For example datediff(dd,open_date,getdate())..

Open date is stored in timestamp format.

Please help me.