Smallest interval (3 seconds)? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kemes, Lisa Sent: Monday, June 11, 2007 4:45 PM To: [email protected] Subject: Re: Dates in a SQL Query
** Thanks Fred! One more question, this is a display form, other than "Lose Focus" what other "Execute On" value can I use to show that one of the date fields have changed? Lisa ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, June 11, 2007 4:01 PM To: [email protected] Subject: Re: Dates in a SQL Query ** 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. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007 1:39 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
