>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

This works for SQL Server, don't know about MYSQL:

..WHERE table1.dttimefld >= '20040801' AND table1.dttimefld =< '20040901'