Posted by Skybuck Flying on 01/06/08 15:25

The finally code would have looked something like:

(Birthdate < '06/06/1979')

Since Birthdate is a date field the SQL interpreter could have known the
string should contain a date.

Anything else would not make any sense ?!?

Bye,
Skybuck.

• Next in forum: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)
• Prev in forum: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)
• Thread view: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

[Reply to this message]