Function field to calculate Ageing in Report Designer

[Piyush Dwivedi]

How to calculate ageing via function field in Report designer

Ageing calculation is basically a difference between created date and current date

[Nishant8]

Hello @Piyush Dwivedi, you can't do the date calculation in function field directly in Report. However, you can create a function filed in the respective table and select the same while creating the report. 

please use following script in the function field:

glidefunction:datediff(now(),created_date)

Regards,

Nishant

[Tom Boudreau]

I will note this order matters and that there were older postings saying you could not use now() in a function field but it seems you can now (I tested in Xanadu). Created_date field is also typically: sys_created_on

[daisyk]

Hello,
Calculating "ageing" in a Report Designer typically involves determining the difference between a specific date (e.g., invoice date, created date, last updated date) and a current or reference date. The exact steps and functions will vary depending on the specific Report Designer software you are using (e.g., SAP, ServiceNow,

[Ankur Bawiskar]

@Piyush Dwivedi 

very well explained here

Function Fields in ServiceNow Reports: Calculate and Display Data on the Fly 

Remember you cannot use now() directly but there is a trick to update that field in dictionary

As per the link I shared it says invalid syntax, but there is a workaround for that

It worked fine for me see below when I used that workaround

If my response helped please mark it correct and close the thread so that it benefits future readers.