Hi Roland,

I'm having a guess here, but how about

TTOD(birthdate) = DATE()

Hope this helps,
Gavin...


>I AM TRYING TO CREATE A REMOTE VIEW USING VIEW DESIGNER. FILTER BY BIRTHDATE = EXAMPLE. I DON'T KNOW HOW TO EXPRESS THE EXAMPLE AS TODAY'S DATE. I HAVE TRIED BIRTHDATE = CURDATE(); BIRTHDATE = DATE(); DOES NOT WORK. THE BIRTHDATE IS AN SQL DATETIME FIELD.
>
>THANKS IN ADVANCE!
>ROLAND