Function field to calculate Ageing in Report Designer

Piyush Dwivedi
Tera Contributor

How to calculate ageing via function field in Report designer

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

1 ACCEPTED SOLUTION

@Piyush Dwivedi 

that's correct, it won't allow you to write now() but you can go to dictionary and update that script

the 1st screenshot is from the article I shared

sharing again

AnkurBawiskar_0-1751511588422.png

 

 

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

8 REPLIES 8

Thanks for the response @Ankur Bawiskar your first snapshot is not visible.

Can you please guide me.

so first i need to create a new function field as "My duration" where i need to add this script then same custom field i need to call it during report, right?

@Piyush Dwivedi 

that's correct, it won't allow you to write now() but you can go to dictionary and update that script

the 1st screenshot is from the article I shared

sharing again

AnkurBawiskar_0-1751511588422.png

 

 

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Piyush Dwivedi 

Hope you are doing good.

Did my reply answer your question?

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Thanks @Ankur Bawiskar  It means alot.