calculating the difference between times

Discussion created by andruziwa on Nov 20, 2013
Latest reply on Nov 20, 2013 by andruziwa

Could anyone offer some suggestions for how to calculate the difference between times?


I have played around, searched around the internet, searched for custom functions and failed.


I want to see if appointment records for the same day are greater than 30 minutes or 60 minutes behind the current time. I am using this to conditionally format a portal list of appointments to highlight appointments that are supposed to have happened.


I am currently using the expression: get (current time) - local_appts::appointment time > 0 to successfully highlight appts that are past due but I cannot differentiate between ">0" and ">30" or ">60."


Thank you in advance for any advice on this.