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?