Time Since Now() in a Function Field in a Report

[jmiller0666]

I have used the function field feature in reporting. I want to do a function that tells me the number of days (duration) since the last update. This means that I need to know today's date/time - Now(). I cannot use any other functions (other than those listed). Is there a way to do this?

[JagjeetSingh]

Hi,

You can't do this directly through function field. One way to do this is to have a custom field on your table which holds the current date and time.

Then using function fields you can show the difference in "duration". See below.

Mark my response correct or helpful if it answers your query.