CUIC 8.5(4) Daily Summary Report Doesnt Time Zone Adjust On Display

[Faisal Zaidi]

User configured in a EST (GMT -5) the system is in CET (GMT +1)

When the report is run the DateTime passed to the query is adjusted, ie, if an American user select 21st Oct 00:00:00 to 21st Oct 23:59:59 (ie the data for the 21st Oct only is saught) the query run converts the user enetered DateTime to the corresponding system DateTime, ie, 21st Oct 06:00:00 to 22nd Oct 05:59:59.

However, the data returned to screen doest combine the data for the 21st only, there are columns output for the 21st and the 22nd also. The Columns returned are correct in that they are for 21st Oct 06:00:00 to 22nd Oct 05:59:59, but they should be displayed in a single column for the user entered date 21st Oct only.

This only seems to affect the Summary reports available to download here and not the CUIC stock reports which display correctly. Please complare the 'Agent Summary - Daily' summary report with 'Agent Historical' stock report - screen shots can be provided if required.

Is there a simple way to ensure the data rendered on screen displays the user entered date only or will this require manual manipulation of the SQL to achieve?

Thanks! 

[ayush.shyam]

You need to add or remove GMT hours by using the separate custom function during run time of query. Like if you are running the report in India then you have to make a custom function which will except the date time. And will add +5:30 hours in existing time.