Re: How calculate the Aging of an Incident & show it in overview console?

I am off to bed so I'll be a little sparse on the detail in this reply... The DB view U__HPD_Help_Desk is an out of the box view, I only added a column to it. That view and one for each of the other forms Change, Problem, Work Order, Task, etc. also have similar out of the box DB views. When all i

Re: How calculate the Aging of an Incident & show it in overview console?

Thanks a ton Jason. Also i will try to impalement it & will keep you posted on it. One query - Also after adding the custom column in "U__HPD_Help_Desk" is it mandatory to add the dummy columns to every other view used in the Overview UNION view. After that we need to simply add the new colu

Re: How calculate the Aging of an Incident & show it in overview console?

Thanks a ton for your superb response. Also regarding the DATEDIFF() - > please could you let me know that are you calculating it for the difference between Submit Date & current date?? -- Sent from: http://ars-action-request-system.1.n7.nabble.com/ -- ARSList mailing list ARSList@arslist

Re: How calculate the Aging of an Incident & show it in overview console?

That is correct. Well, current timestamp (includes time too) The getdate function in SQL Server (don't remember you saying which DB you are using). https://docs.microsoft.com/en-us/sql/t-sql/functions/getdate-transact-sql "Returns the current database system timestamp as a datetime value without