Create 2 Display Only Integer fields on your form (zInt1 and zInt2) Set zInt1 = $Start Date$ Set zInt2 = $End Date$
Then use the 2 Integer fields in your SQL Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, June 11, 2007 1:35 PM To: [email protected] 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
