I need an age calculation formula that will look for blank DOB fields and display nothing for the age field. The formula I have excludes all of the name if the DOB is blank.
Age Formula - INT((CurrentDate-{name.dob})/365.25)
Entire Name Formula -
local stringvar ls := trim({name.lastname}) & " " & trim({name.suffix});
local stringvar fm := trim({name.firstname}) & " " & trim({name.middlename});
local stringvar fn;
If length(trim((ls))) > 0 and length(trim((fm))) > 0 then
fn := trim(ls) & ", " & trim(fm)
else
fn := trim(ls) & trim(fm);
If length({name.race}) < 1 then
local stringvar rc := "-"
else rc := {name.race} & "/";
If length({name.sex}) < 1 then
local stringvar sx := " - "
else sx := {name.sex};
fn & " - "& trim (rc) & trim (sx) & " "& " " & trim ({name.age})