>Thank Fabio,
>
>It was a simplified example....:)
>
>THIS.ccondit1 = [((ISNULL( E.iid )=.T. AND ?dvd => TTOD(R.dentree) AND ( ?dvd =< TTOD(R.dSortie) OR R.dSortie ={})) OR ]+;
> [(?dvd >= E.dDebut AND (?dvd =< E.dFin OR (E.dFin={} AND (!E.lTransfert OR R.dSortie = {} OR ?dvd =< TTOD(R.dSortie))))))]
> > >i can use this code
>.ccondit1 = STRTRAN( .ccondit1, "dvd", "date()" , 1 , 25 , 1)
>
>
>bernhart
>

Hi Bernhard,

don't make this, it is mistaken on VFP.

VFP eval DATE() on any scan/seek
( if you start a long select at 23:59:59 and and at 00:00:01
you can have turns out to you completely mistakes to you )
and the query run slowly

Fabio