Joe Hecht
jmhecht at earthlink.net
Wed Feb 8 14:15:01 CST 2006
The idea here is get the difference in years between 2
dates.
This is a global module.
Public Sub yearcalc(date1 As Date, date2 As Date)
= int(Datediff("m", date1,date2)/12)
End Sub
=int line returns syntax error
This is the code I want to call the above
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim DOB As Date
Dim txtIDATE As Date
Set DOB = date1
Set txtIDATE = date2
Call yearcalc
Thanks
Joe Hecht
jmhecht at earthlink.net