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]

####################################################################

Thank you very much.