CUIC - Service Historical -  Separating DateTime into different fields

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode
This document was generated from CDN thread

Created by: Kieran Byng on 04-01-2013 08:12:02 AM
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!