Package Manager Console In Visual Studio 2010

If I use the column as is then it is giving time 12:00 am with each date.
If I substring the value in report only for date then it works for HTML
and PDF format but in Excel it is giving strange number.