what is the format of rsGS__v_ExamDt1?

jaya
----- Original Message -----
From: "Matt Lepore" <mlepore@f...>
To: "javascript" <javascript@p...>
Sent: Thursday, July 19, 2001 8:12 PM
Subject: [javascript] replace method


> I'm working on a SQL query in Oracle and everything is working properly
> except for the option to search between 2 dates. This is the part of the
> code that is giving me problems.  I don't know if I have the replace
> method syntax correct.  I just want the user to be able to enter 2 dates
> and have the databse return the data between those dates. Any help would
> be greatly appreciated.
>
>
>  m_studies.study_date
>  between to_date(rsGS__v_ExamDt1.replace (/'/g, ' '),'DD-MON-YYYY')
>  AND to_date(rsGS__v_ExamDt2.replace(/'/g, ' '),'DD-MON-YYYY')
>