>Hi all,
>
>Is there any way to display only the date part of SQL Server DateTime Field, in a recordset?
>
>My form textbox are bound like thisform.ors.fields('datac').value. What i want is display only the date part, and the user only input de date.
>
>Thank's
>
>João
I used different convert options for it
Look syntax of MS SQL server convert function
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.