I have a datetime field in SQL Server that is being pulled into the datareader. I'm trying to display it like so:
lblEstCompletionDate.Text = dr["EstCompletionDate"].ToShortDateString();
I'm trying all kinds of things and just can't get it to display in a mm/dd/yyyy format. I'm not sure why the above does not work. I'm getting:
'object' does not contain a definition for 'ToShortDateString'
What is the propper way to accomplish what I'm trying? If it's not ToShortDateString, what is it?
Thanks in advance.