Raj,
Please show the rest of the code that actually makes use of what you are putting into the lcSQL memvar.
Are you getting a specific error?
>I am using the following, but the strt_dt and to_date is not carried over inside the query. for between date condition.
>################################################################
> strt_dt = date() - 7
>
> to_date = date()
>
> LcSQL = [select distinct(a.tiffile), b.proj_no, b.workpkg_no, b.docindex_i from ocrdata a, docudeck b ;
> WHERE UPPER(b.file_name) = UPPER(a.tiffile) ;
> and BETWEEN(a.created_dt, strt_dt , to_date) ;
> order by a.id into Cursor lcSource]