VBA Date Problem

[JMichaelM]

I am having great difficulty trying to resolve this. WCCNF1 should turn to yes for previous dates in 2015 not 2016. I cant get it to work using -1. If Year = 2015 it should turn to Yes. Can anyone help me?
If (Year(Nz([WCCClmDt1])) = Year(Date)()) Then
WCCNF1 = "Yes"
ElseIf (Year(Nz([WCCMRDt1])) = Year(Date)()) And _
(Year(Nz([wccmrdtwgt])) = Year(Date)()) And _
(Year(Nz([wccmrdthgt])) = Year(Date)()) Then
WCCNF1 = "Yes"
Else
WCCNF1 = "No"
End If

[Seth Schrock]

Try this:

If Year(Nz([WCCClmDt1], 0)) = (Year(Date) - 1) Then
    WCCNF1 = "Yes"
ElseIf Year(Nz([WCCMRDt1], 0)) = (Year(Date) - 1) And _
        Year(Nz([wccmrdtwgt], 0)) = (Year(Date) - 1) And _
        Year(Nz([wccmrdthgt], 0)) = (Year(Date) - 1) Then
    WCCNF1 = "Yes"
Else
    WCCNF1 = "No"
End If

You had extra parenthesis and I'm not sure where you put the -1 before, but this should work.

[PhilOfWalton]

Your question is not very clear.
If you are trying to get "No" if wccmrdtwgt is this year and "Yes" ir it is a previous year then this bit of SQL will work

 IIf(Year([WCCMRDt1])=Year(Date()),"No","Yes") AS Expr1
 

If you need a different result you need to explain what input you have and what output you want

Phil

[JMichaelM]

Already figured it out thanks.