CUIC - Service Historical -  Separating DateTime into different fields

Version 1
    This document was generated from CDN thread

    Created by: Kieran Byng on 04-01-2013 08:12:02 AM
    Hello,
    I'm trying to change the Service Historical report to allow for Date and Time to be separate fields so that I can group by time (without Date) to allow us to compare time intervals performance across weeks & months.
    I've tried using CONVERT(char(8),CTHH.DateTime,108) as Time & CONVERT(char(10),CTHH.DateTime,101) as Date and although the report does validate it corrupts the report when trying to view/run them. (It corrupted all reports based on this def and wouldn't let me 'undo' and didn't like it when I restored it to it's previous state - learnt my lesson!)
    Does anyone have any ideas on how I could get round this or what I should be trying?
    Any help is much appreciated! Thanks!