At 12:57 PM 1/5/2000 -0600, you wrote:
>John,
>
>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
----- 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