Could someone please direct me on how to create a field that generates the 'age' of a document in days (not years).

I can find the help file on calculating date of birth but I don't really understand the formula and which section to remove to convert back to days.

((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2)

I am confused why (zoho.currentdate - documentdate) doesn't appear to work.

Also will this field only update on creation and if so how do I get the field to constantly update each time the application is opened?

Many thanks for your help.

Best regards

John MacPherson
www.saffuze.com