Hi John,

Sorry about the caps. Just using a PC.

I can't seem to use any of vfp functions in the example. ie. DATE(),TTOD() etc.

Please explain or tell me what can be used in the example field.

Heres what I would like to use because birthdate is a DATETIME field:

TTOD(dbf.birthdate) = DATE(); but that does not seem to work.

Thanks in Advance!
Roland
=================================================================
>First off, Roland, kill the Caps....you're not using an Apple ][+ I suspect. :-)
>
>The way to pass dates to SQL Server is as a string delimited by quotes. For example:
>
>birthdate = '01/01/2001'
>
>Try setting a property or var to the strong date and making the view birthdate = ?myobject.myproperty
>
>
>
>>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