Custom Property - Date item populates system with correct date but reports with day before 11pm

Tuesday, October 7, 2014 8:26:36 AM
We have noticed that when adding a customer property to a incident that is in a Date format, when populating with say 10/10/14 on screen in Spiratest it actually outputs on custom reports as 09/10/14 23:00 which when truncated gives 09/10/14.

Why is it populating the custom report with the day prior and other than manually updating the date in Spiratest or a XLS formula is there any way to rectify the issue?
1 Replies
Tuesday, October 7, 2014 12:40:08 PM
Avatar
re: keaney2023 on Tuesday, October 7, 2014 8:26:36 AM

Hi Grant

This is because we store the dates internally as UTC dates.

I have logged an enhancement to have the report writer localize them before displaying them (it already does this for standard reports).

Regards

Adam

Statistics
  • Started: Tuesday, October 7, 2014 8:26:36 AM
  • Last Reply: Tuesday, October 7, 2014 12:40:08 PM
  • Replies: 1
  • Views: 365