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.