I have a columm in my table set as a "short date"
it is displayed as 23/08/2011
but when I click in to the table it comes out as 23/08/2011 09:18:00.
can I use a function to convert it to 23/08/2011
I ma trying to use it in a group query but keep geeting the wrong answer as all the times are shown