Greetings,

I have a field that is using datetime datatype. I have gone into Format Field and adjusted so the output only shows the date, and not the time. However, after I export the report results to Excel, this particular date field does only show the date in the cells (which is how I want it). But, if you highlight a cell, then it shows both the date and the time in the cell edit box. This makes it difficult when I do sorting because I only want to have to deal with the date - not the time.

I do not want to convert the datetime field to a string in Excel. I want it to remain a date, but not date and time.

Is there some sort of conversion that I can run on the datetime field to accomplish this?

Also, does anyone know the formula to use in a SQL stored procedure or the query analyzer to accomplish this?

Thanks in advance,

Pat B.