Dates in a SQL Query

[Kemes, Lisa]

I have a simple count SQL query that sets a field on my form: 
 
SELECT COUNT(SURVEY_NUMBER) from TEIS_SURVEY_CALCULATIONS Where
AVGSCORE_7 > 0   
 
I would also like to query it more by adding date fields.  I have a
start and end date on my form, but how do I translate this into at SQL
Query?  
 
I know if I simply do this:
 
SELECT COUNT(SURVEY_NUMBER) from TEIS_SURVEY_CALCULATIONS Where
AVGSCORE_7 > 0   and EXP_DATE >= '$Start Date$' and EXP_DATE < "$End
Date$' 
 
I'm not going to get what I need.  My EXP_DATE field is truly just a
date field, not Date/Time
 
We are using AR System 6.3
AR User 6.0
Oracle 9i and Sun Solaris. 
 
 

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"