Could anyone offer some suggestions for how to calculate the difference between times?
I have played around, searched around the internet, searched BrianDunning.com 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.