X
xerxov
I'm trying to calculate an age on a form using this datediff function.
Can anyone tell me why i just get #name? I created an 'age' field in
the table, and on the form in the control source for the 'age' field i
entered this where BDATE is the birthdate, and 17YRCADD is a test date
at which i need to determine the age. I know next to nothing about
vba so treat this like you are speaking to a total beginner.
=Abs(DateDiff("yyyy",[BDATE],[17YRCADD]())+(Format([BDATE],"mmdd")>Format([17YRCADD](),"mmdd")))
Thanks for you help.
Rob S
Can anyone tell me why i just get #name? I created an 'age' field in
the table, and on the form in the control source for the 'age' field i
entered this where BDATE is the birthdate, and 17YRCADD is a test date
at which i need to determine the age. I know next to nothing about
vba so treat this like you are speaking to a total beginner.
=Abs(DateDiff("yyyy",[BDATE],[17YRCADD]())+(Format([BDATE],"mmdd")>Format([17YRCADD](),"mmdd")))
Thanks for you help.
Rob S