Date comparison problem.

[bubai]

I want to compare two dates in Vba with Boolean operators. How to do it? One is coming from a text box control of my form. Other I put as a value. I tried-
MyBoolControl = NZ(myTxtcontrol, Year(#1/1/1901#)) <> Year(#1/1/1901#)


But it's not working. Also tried Format but in vain.

[ranman256]

just : year([date1]) <> year([date2])

[Micron]

What you have should work, but "not working" means what?? Wrong result? Error message? Something else?

[bubai]

What you have should work, but "not working" means what?? Wrong result? Error message? Something else?

It works on it's own, but when I have added multiple criteria for multiple controls it wont change MyBoolControl value accordingly. I guess I have to check each of them individually.

[bubai]

Sorry Guys....
I think I have found out the problem.
There was a criteria where I had put the following code

Nz(Me.CNF_Bill, (-1)) > (-1)

Somehow it changed my CNF_Bill field's value from 0 to -1. I used -1 to allow for 0 value bill (ie. for which we don't have to pay the bill at all). Now it seems to be working fine.
Sorry again to have bothered you guys. Bug fixing appears to be a really rigorous task!!

[Welshgasman]

Sorry Guys....
I think I have found out the problem.
There was a criteria where I had put the following code

Nz(Me.CNF_Bill, (-1)) > (-1)

Somehow it changed my CNF_Bill field's value from 0 to -1. I used -1 to allow for 0 value bill (ie. for which we don't have to pay the bill at all). Now it seems to be working fine.
Sorry again to have bothered you guys. Bug fixing appears to be a really rigorous task!!

What do you mean somehow?
The value in that control would have been Null for that to happen, not 0?

[bubai]

What do you mean somehow?
The value in that control would have been Null for that to happen, not 0?

I'm not sure at what stage of my coding and testing it has changed, but my purpose was to allow for rowlock using -1 as well as to allow for 0 so that I can keep track for CNF bills which I won't have to pay.