I have a Date of Report field, a Date of Birth field and next to it we compute Age; how can I fill the Age field automatically based on DOB and the original date of the report?
var date LDD = [Latest Dev Date]; var date PolicyDate = Today();
var Number Age = Year($PolicyDate) - Year($LDD) - If( Month($PolicyDate) < Month($LDD) or (Month($PolicyDate) = Month($LDD) and Day($PolicyDate) < Day($LDD)),1,0);