Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

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  ||  ✨ 10x 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  ||  ✨ 10x 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  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader