Hello @maretval, 
We have date created(mm/dd/yyy hh:mm AM/PM) and Completed Date (mm/dd/yyyy) formats in the Cases module.
Now, we want to find the number of days between date created & completed date. How could we do it in the kreporter?
With a custom SQL Function. In my example I count the number of days between date_entered and date_closed in the opportunities module.
I dragged date_entered whoch is represented by {t}.{f} in the SQL function.
Then you need to override the field type in the presentation for the number of days. Since the field you drag is of type date, you have to change it to integer
1 Like