Posted by David Kerber on 01/07/08 14:29

In article <90be5$4780a525$541983fa$11100@cache2.tilbu1.nb.home.nl>,
spam@hotmail.com says...
> Following SQL example works:
>
> (Birthday <> null) AND
> (Birthday > #06/06/1978#) AND
> (Birthday < #06/06/1979#)

The #'s tell me you're working with Access, which is probably the least
standards-compliant database you can find.

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

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

[Reply to this message]