Hi,
I have a straight forward table with a field called DATE. I run a query on that table so that I can create a Report selecting data between 2 dates.
What I want to do now is to create a new field in the query that displays the actual day of the week (Monday, Tuesday etc). I have tried...