03-24-2011 08:37 AM
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
Solved! Go to Solution.
03-28-2011 08:34 AM
This works fine for me.
Try using the Build Query button and see if that works.
03-28-2011 12:12 PM
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!!