Re: FN-FORUM: SQL less than or equal to operator problem

date posted 13th January 2007 14:19

thanks again Sam

On 13 Jan 2007 14:46:48 -0000, Sam M - www. wiredeyes. com
[EMAIL REMOVED] wrote:
>
> '13/01/2007' meens '13/01/2007 00:00:00'
>
> If you have a datetime field set with '13/01/2007 12:35:00' it is after your
> date. Make your db field just a "date" field instead of a datetime field or
> make your date '14/01/2007' using the dateadd function
> http://www.w3schools.com/vbscript/func_dateadd.asp
>
> Regards
>
> Sam Morgan
>