To calculate the open days of a major problem from opened_at to today, need report that shows count

[HarshaVardhanB]

There is requirement of creating a report of number of days the problem is opened, based on the opened/created date to today for a major problem record, without modifying/creating a field column on Problem table 

[Bhuvan]

@HarshaVardhanB 

I checked on this and function field in report designer do not support fetching today's date/time for comparison (current date/time - opened_at). You can use glidefunction only on existing date/time fields in the table you are reporting on & date/time field values are available, for example

glidefunction:datediff(closed_at, sys_created_on)

When you try to use now() or any other function to get date/time runtime, it does not work. 

Alternate option is to create a function field in sys_dictionary and calculate the value using function definition. Refer below article for the steps,

https://www.servicenow.com/community/developer-forum/how-to-fetch-today-s-date-in-configure-function...

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@HarshaVardhanB 

Did you get a chance to review this information ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan