I have a few date fields on my report and i cannot get them to convert in the correct format.
The default is 08/28/2010 2:30:00 PM and I have used CONVERT(Varchar, EndDate, 103) to convert it to 28/08/2010. But the new date comes out as text format (string) when I copy results into Excel and I want it to stay as a Date type.
Can anyone help please?
View Complete Post