Edgar,

There's no reason to use SYS(11) because dates can be compared directly

select * from compromisos 
  where compromisos.feccompromiso BETWEEN m.ini AND m.fin ;
     OR ( compromisos.flag AND compromisos.feccompromiso < m.ini) ;
            order by cliente;
            into cursor curcompromisos
            Repor form compromisos previ

>Hello i have the half of my query builded:
>

>select * from compromisos where Sys(11,compromisos.feccompromiso) >= sys(11,m.ini) and;
>            Sys(11,compromisos.feccompromiso) <= Sys(11,m.fin);
>            order by cliente;
>            into cursor curcompromisos
>            Repor form compromisos previ

>this query is for a range of date, but i need to include here
>to validate the date < = to m.ini and a logical field equal .T.
>
>How i do this, do i have to do a subquery if it is so, how?
>
>Thanks for your help.