Time showing wrong

surya123
Mega Guru

Hi All

I am checking the time  on my incident record and it shows something different.

Incident is created at 02-14 02:49:35 PM

When i run a BG script, it shows the it as 2018-02-14 20:49:35

My timezone on user record is set to System.

Can someone tell me how can i get it correctly

 

Thanks

Surya

8 REPLIES 8

System properties has System(Central)  and user record also has the same. But since i am doing at background script i see the difference. I need to get the correct time to compute in PA buckets. Else it is showing wrong value.

ccajohnson
Kilo Sage

Your original question sounded to me like the date format was incorrect and that the expected date format to show on all records was supposed to be yyyy-mm-dd. Now I need to ask what your ultimate goal is. You mention background scripts, and PA buckets and that to me does not match with the original ask. Please let us know what you are trying to do so we can focus our solution accordingly.

What I was trying to do is, from the pa script 'Task.Opened.HourOfDay' I was trying to check the scorecard for the incidents. But I saw the numbers were not matching as they were going to another hour bucket instead of what i was seeing on the record. So when i run the background script I got to know what is being returned by the pa script that it is showing in the bucket. So, I was just trying to rectify this Pa script so that the incidents falls into proper bucket.

 

Thanks 

Surya

Is there a way we can do this?