S
scs
I have the following calculated field in a query. It works great except
when I don't have a Date of Birth entered. Then it displays Err. Is there
a way to display something different or nothing at all? Or is there a way
to display it differently on a form?
Here is the formula I am using:
Age:
IIf(Int(Format([DOB],"y"))>Int(Format(Date(),"y")),DateDiff("yyyy",[DOB],Date())-1,DateDiff("yyyy",[DOB],Date()))
TIA
Steve
when I don't have a Date of Birth entered. Then it displays Err. Is there
a way to display something different or nothing at all? Or is there a way
to display it differently on a form?
Here is the formula I am using:
Age:
IIf(Int(Format([DOB],"y"))>Int(Format(Date(),"y")),DateDiff("yyyy",[DOB],Date())-1,DateDiff("yyyy",[DOB],Date()))
TIA
Steve