age calculations help

[5835]

hey guys,

my first problem is with a calculated age field. to calculate the age, it needs "todays date"(which is automatically found) and DOB. Sometimes i dont know the persons Dob so i leave the field blank but the calculation still goes. is there anyway i can make the calculation stop if "dob" is empty. Also, will it let me put the age in manually without the DOB.
thanks

 

[itsisnofun]

5835

You can use ether the IF statement or the Case statement for this. You will not be able to type in that field where the calc is but you can add a another field and use one of the above to get which ever one had data.

Mike

 

[kertusa]

case(
not isempty(DOB) and isempty(DOB Override Field),
status(currentdate) - DOB,
DOB Override Field
)


Something seems clumsy here, but that would be my first approach