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

date posted 13th January 2007 13:58

'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

WiredEyes
tel (Uk): +44 (0)20 7100 2178
tel (Italy): +39 070 766 242
web : www.wiredeyes.com
----
umop ap!sdn w,! aw dlaH


> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Paul
> Cooper
> Sent: 13 January 2007 15:36
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: SQL less than or equal to operator problem
>
>
> Hi
>
> I've come across an issue to seems rather odd. I have a record in a
> table that has a date field with the value of 13/01/2007 (today). The
> field is called Generated date.
>
> When I do this the record is not found:
>
> WHERE GeneratedDate >= ' 13/01/2007 ' AND GeneratedDate
> When I do this the record is found:
>
> WHERE GeneratedDate >= ' 13/01/2007 ' AND GeneratedDate
> When I do this the record is not found:
>
> WHERE GeneratedDate >= ' 12/01/2007 ' AND GeneratedDate
> So it suggest the equal to part of the less than or equal to operator
> is not working. The equal to part of the greater than or equal to
> operator is working though. I've also tried the BETWEEN AND operators
> but it has the same behaviour.
>
> Can anyone explain this and suggest a solution.
>
> TIA
> Paul
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>