Please forgive my ignorance.... Or poor explanation
I have just run:
SELECT CONVERT(date, CALLDATEANDTIME) AS Date
But get an error saying Error Message: Cannot call methods on date
The field called CALLDATEANDTIME is the field I am trying to convert.
What am I doing incorrectly?