Days Job Active
With the help of posts on the web I've managed to get our company Filemaker Pro 10 database to run calculation field that gives the number of days any job has been active. The calculation field is:
Get ( CurrentDate )-Date Created
Very simple stuff I know. The problem I have is that not all jobs are active of course so even closed jobs are returning a figure. We know if a job is active from a text field showing a checkbox set with a value list of 'Active' - if it's clicked on then it's live.
Can anyone suggest how do I might tell Filemaker to look at this field, see if it's active, if so, do the above calculation and return the number of days, otherwise reply with something like 'Closed'?
I've looked at the 'IF' command but the advice didn't seem to work with a checkbox.
Thanks for any help.