I have created a custom form in outlook and created a text box that once I've entered a date of birth for someone it tells me the age. The problem is on some, not all it is giving me the wrong age, seems to happen with only young children, saying 1 when its really 2 or 3. Can anyone see what is wrong?? Also, is there a way in outlook to give me the age in years and months?
This is what I currently have:
IIf([D.O.B.]<>"None",DateDiff("yyyy",[D.O.B.],Date())-IIf(DateDiff("d",CDate(Month([D.O.B.]) & "/" & Day([D.O.B.]) & "/" & Year(Date())),Date())<0,1,0),"")
This is what I currently have:
IIf([D.O.B.]<>"None",DateDiff("yyyy",[D.O.B.],Date())-IIf(DateDiff("d",CDate(Month([D.O.B.]) & "/" & Day([D.O.B.]) & "/" & Year(Date())),Date())<0,1,0),"")
