nested IFs not working, though top-level does

[viveleroi]

The first level of IFs work fine, but none of the inner ones work. I'm new to VBA but not new to programming... why won't these work:

If (rs.Fields("EmployeeStatus") = "Non-Exempt") Then
initPTO = 20

If (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 25) Then
initPTO = initPTO + 15

ElseIf (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 15) Then
initPTO = initPTO + 10

ElseIf (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 5) Then
initPTO = initPTO + 5

End If
ElseIf (rs.Fields("EmployeeStatus") = "Exempt") Then
initPTO = 25

If (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 25) Then
initPTO = initPTO + 10

ElseIf (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 10) Then
initPTO = initPTO + 5

End If
End If

 

[modest]

If (rs.Fields("EmployeeStatus") = "Non-Exempt") Then
    initPTO = 20

    If (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 25) Then
        initPTO = initPTO + 15

    ElseIf (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 15) Then
        initPTO = initPTO + 10

    ElseIf (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 5) Then
        initPTO = initPTO + 5

    End If
ElseIf (rs.Fields("EmployeeStatus") = "Exempt") Then
    initPTO = 25

    If (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 25) Then
        initPTO = initPTO + 10

    ElseIf (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) >= 10) Then
        initPTO = initPTO + 5

    End If
End If

I didn't change anything... I just did this so that it would be easier to read, for whomever wanted to look at it.

 

[modest]

One of 3 things is happening.

1) if rs.Fields("CorportateHireDate").Value isn't the right format of a date, this will be wrong

2) if rs.Fields("CorportateHireDate") is in the future, Datediff will return a negative... so put Now as the third parameter

3) if abs(DateDiff("yyyy", Now, rs.Fields("CorportateHireDate")) will give you the pure difference no matter what the value is.. if it's in the future or in the past, the difference in years will either be positive or 0.


hope this helps,
modest