So I have been trying to get the parts of a date and then adding up the numbers of the date parts
Dim d1 As Integer
Dim d2 As Integer
Dim d3 As Integer
Dim d4 As Integer
If Not IsNull(Me.BDAY) Then
d1 = DatePart(m, Me.BDAY)
d2 = DatePart(d, Me.BDAY)
d3 = DatePart(yyyy, Me.BDAY)
d4 = d1 + d2 + d3
Me.LPATH = d4
I get an improper procedure call error.
Can someone help me with converting d1,d2, and d3 to integers so I can add them together.
TIA
Stephen