Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to fetch today's Date in Configure Function Field in a report

Mubashira
Tera Contributor

I am trying to apply a datediff() function to create a date difference field. How can I fetch today's Date to subtract it from sys_created_on field in Configure Function Field option in a report.

Mubashira_0-1690756909658.png

 

9 REPLIES 9

Hello @Mubashira 

 

Is it not working in Function Field ??

 

 

I am looking for a today's date time function that can be declared in datediff() funtion as one of the argument.

Hi Mubashira,

 

Any luck here? I am also facing the same issue.

 

Thank you,

Junaid

 

Bert_c1
Kilo Patron

Hi,

 

You can define a new field on the desired table, that does what is asked here. This was suggested in another thread here by a Community member.

 

Screenshot 2023-07-31 112331.png

 

the add that field to the report.

bhargav ram
Tera Contributor

Did you find the answer?