How can a build a script that would automatically calculate the age of a problem ticket.
I want to be able to calculate how long a ticket is open. I have a beginning date and time when a ticket is opened. I want to be able to put a end date and time when closed. But I also want the age to automatically calculate.
Can someone help? It seems like I did this years ago when I first started using Filemaker, but I seem to have forgotten what I did.