If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query result inquiry
If you run this and the Birthdate is 9/1 I come up with -1 for the result.
Wondering why this would not be zero or 1 Int("0901"=Format(Birthdate,"mmdd")) David Bartosik MS MVP www.davidbartosik.com |
#2
|
|||
|
|||
query result inquiry
In Access, -1 is true, 0 is false. In some other programs, 1 is true and 0 is false.
The reason is basically that this was a choice made by the designer/programmers. David Bartosik MS MVP wrote: If you run this and the Birthdate is 9/1 I come up with -1 for the result. Wondering why this would not be zero or 1 Int("0901"=Format(Birthdate,"mmdd")) David Bartosik MS MVP www.davidbartosik.com |
Thread Tools | |
Display Modes | |
|
|