Try :
select * from calls
where calldate > '01/01/2000'
and acctstatustype = 2
Hope this helps.
Steve Pierce, MCSE
Dynasty Online, Inc.
Internet Solutions
http://www.dynasty.net
John Lange wrote:
>
> HI & Thanks for Your Help
>
> I have been trying to learn to write my own SQL queries, and have been
> successful to a point. I just cannot seem to get the "smalldate" format
> correct.
>
> select * into calls2 from calls where acctstatustype = 2 and calldate >
> January 01 2000 00:01AM order by calldate
>
> This statement ALWAYS errors out on 01 and will go no further. How is
> "smalldate" supposed to be formated?
>
> Thanks Again
> JOhn :}
>
> ----- Whatever you do, work at it with all your heart, as working for the
> Lord, not for men >Colossians 3:23 (NIV)
>
> John C. Lange, Sr. PALACE dot NET, INC.
> microjl@palacenet.net MICRO-TECH Computers, Inc.
> 608.742.1601 & 6980 1819 New Pinery Road
> http://www.palacenet.net/ Portage, WI 53901
> MSCE Training for only $150.00 - http://dpec.palacenet.net/
> All 200+ Web Based Courses for $150.00 Per Year - "Really"
>
> --- __o
> --- _-\<,_ Fastest Service in Town
> --- (_)/ (_)
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart