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