Do you have any other values ticked in your Checkbox Set? if so try the following:
If ( Patterncount ( JobStatus ; "Active" ) ; Get ( CurrentDate ) - Date Created ; "Closed" )
JobStatus being your checkbox field.
I hope this helps
Hi Orlando, thanks for the reply.
No there only seems to be one value.
Job Status field is a text one, indexed - showing as a Checkbox set - displaying Values from a list called 'Active' - with Custom Values with one entry 'Active'
I'm not sure why it was done this way I would have thought there would have been another entry in the list 'Closed' but this seems to be in another field made the same way as this one.
I've tried your line and it currently replies 'Closed' for all jobs.
Not sure why they will all show as "Closed", sounds like the field is setup ok, you may want to check the actual value in the Job Status field. You can do this by making a second copy of the Checkbox on the layout and making it a standard text field. then in browse mode check the box and see what value is placed in that field.
You could add a second value of Closed if you like, but it sounds like its setup to just have the value of "Active" or be Empty, and the calc in my previous reply should calculate the days if the field have "Active" in that field.
Let me know how you get on with this.
What you suggested got me checking again and it turns out that there are several similar fields some of which look like they are redundant. Turns out that Job Status wasn't the key field I needed but a similar one called 'Active' - I find the similar naming that is used quite confusing.
Anyhow it's working like a charm now. Thanks for nailing this for me.
No worries Ray, glad I could help.