SQL "Date" Code - What am I Missing??

[slsl]

Hi Everyone,

I know this shouldn't be difficult, but none the less am stumped by this little item...

From ADMIN app I go and run a 2 line SQL code

Line 1: Select * from Activity

Line 2: Where Startdate < '12/31/2010'

Seems simple and easy enough!!

But then I get records with a Startdate after 1/1/2011 (Please see attached JPG).

So what am I missing??

As always, thanks in advance!!

Joe

[EmmaNixon]

This works fine for me. 

Try using the Build Query button and see if that works.

[slsl · Accepted solution]

Hi Emma,

Actually you gave me an idea with the Build Query tool!!  I slapped together a one line code snippet and I noticed the difference in how the STARTDATE field was selected/formatted -

where startdate < '20101231 00:00:00'

versus

where startdate < '12/31/2010'

and the "new" code presented the correct values!!

No, I don't know why, but hey, I'm not complaining so thanks a bazillion for the assist and have a good day!!