>Select * from myTable where ExitDate between >date(1,PassedMonth, PassedYear) and gomonth(date(1,PassedMonth, PassedYear),1) >into cursor curResults nofilter>
>SET FILTER TO between(ExitDate, date(1,PassedMonth, PassedYear), gomonth(date(1,PassedMonth, PassedYear),1) )>
>SET FILTER TO between(ExitDate, date(1,PassedMonth, PassedYear), gomonth(date(1,PassedMonth, PassedYear),1) )I would rather use macro expansion to get rid of the variables. What happens when PassedMonth and PassedYear go out of scope ?
local date1, date2 date1 = DateTransform(date(1,PassedMonth, PassedYear)) date2 = DateTransform(gomonth(date(1,PassedMonth, PassedYear),1) - 1) set filter to between(ExitDate, &date1, &date2) function DateTransform(d) return transf(dtos(m.d), '@R {^####/##/##') + '}' endfunc