Configure function field on report

Alon Grod
Tera Expert

 I have a report on metric_instance table. I want to add a function field that will calculate the duration from the start field of type Date/Time to the current time at the moment. What should i write instead of ‘end’?


I attached image

 

16 REPLIES 16

@Nishant8 @Ankur Bawiskar 

 

I attached image

@Alon Grod 

I already shared yesterday that it worked for me

Did you get a chance to check my above comment?

AnkurBawiskar_0-1747904283969.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

@Ankur Bawiskar But 

 

this is not working:

 

glidefunction:datediff(start,now())

 

how can i get current date time instead of now()

@Alon Grod 

I already shared when you enter now() it doesn't allow in function field, but via dictionary you can update it and it supports

Did you check the approach I shared above?

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

@Alon Grod 

Thank you for marking my response as helpful.

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