Hi Eric,

You can't display only the date part. The only work around is to size the control accordingly so you only see the data and not time. Kludgy? Yes. Does it really solve the problem? No. This issue has been brought to Microsoft's attention for the next release of VFP.

- Val Matison

>I was just wondering how people display date values using SQL Server. As you may know there is no date data type with sql server, just datetime.
>
>I want to display a date in a control that is bound to the table. How can I get the textbox to just show the date part, not the whole date and time? I tried using date(table.datefield) in the control source but that dosent work. How do you guys handle this issue?
>
>TIA
>Eric Stephani