SQL Server Dates

[kaijanm]

This should be easy and obvious, but I haven't yet figured it out.

I'm getting data from SQL Server and the dates show up as 1/31/2003 12:00:00 AM. I don't care about the time, I just want to see 1/31/2003.

I tried this, but it doesn't have any effect.
dob = rdrUsers.Item("birth_date&quot
LBirthDate.Text = dob.Date.ToString

Any advice would be helpful!
Thanks,
Kimberly

 

[dragonwell]

get your data into a DateTime object

and use ToShortDateString()

DateTime birthDate = DateTime.Parse("string_from_database")

LBirthDate.Text = birthDate.ToShortDateString()

 

[kaijanm]

THANK YOU! That worked perfectly!