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

[Mubashira]

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.

[Bert_c1]

Hi,

see:

https://developer.servicenow.com/dev.do#!/reference/api/utah/server_legacy/c_GlideSystemAPI#r_GS-dat...

And you show that your use of 'nowDateTime()' is not supported there. Seems you need another way to achieve your goal.

[Mubashira]

Thanks, I have tried but no luck.

[Samaksh Wani]

Hello @Mubashira 

var gdt = new GlideDateTime();

glidefunction.dateDiff(gdt,sys_created_on);

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[Mubashira]

Thank you Samaksh. Actually this works in script but I am declaring parameters in a 'Configure Function Field" in report.