VBA Date Problem

[JMichael]

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

[Bulzie]

Try using -1 and 0 instead of Yes and No.

[pbaldy]

As mentioned elsewhere, your parentheses are goofed up:

If Year(Nz([WCCClmDt1],0)) = Year(Date()) Then

[JMichael]

Interestingly I got it to work using the code below. The problem was the same flag was programmed on another exit at the bottom of the form which I didnt realize. Why is it accepting the format of Year(Date) - 1) when this is not supposed to?

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

[JMichael]

It would take it in that formart

[pbaldy]

Again, your parentheses were goofed up originally.

Also:

cross posters

[JMichael]

OK. Dully noted was unaware of that. Thanks for your response. My method did end up working.

[pbaldy]

No problem.