All date and date/time fields are stored in seconds therefore you will have to calculate it.
-----Original Message----- From: Kemes, Lisa <[EMAIL PROTECTED]> To: [email protected] Sent: Mon, 11 Jun 2007 2:35 pm Subject: Dates in a SQL Query ** 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. __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
