>Hi,
>
>SQL, remote view of MYSQL issue..
>
>What function should I use to get a DATE portion of a DATETIME field ?
>
>..Or, how do I compare those datetime fields with constants data, I mean:
>
>

>..WHERE table1.dttimefld >= ?? AND table1.dttimefld =< ??
>

>
>TIA
>
>Claudio

Claudio,
This is SQLExec(), right ? If so use parameters and let VFP take care of rest. ie:

m.dStart = date()-20
m.dEnd = date()

SQLExec(nHandle,'... where table1.dttimefld between ?m.dStart and ?m.dEnd')

Cetin