DOB/AGE Error

JPR

Registered User.
Local time
Today, 15:48
Joined
Jan 23, 2009
Messages
207
Hello friends,
I have an unbound text box on a form named Age with the following code in the control source box:
=DateDiff("yyyy",[DOB],Date()) & "." & Int(Format(Date(),"mm")-Format([DOB],"mm"))

Unless I type a DOB in the appropriate DOB Text box, the Age text box shows the following error: #Type!
Can this be corrected? Thank you
 
Add Default value to DOB:

Default Value: Date()
 
Thank you. That works fine.
 

Users who are viewing this thread

Back
Top Bottom