We have been trying to utilise the new Function Field functionality that has been exposed at the reporting layer.
One of the really useful functions is the ability to use DateDiff and we can easily see how to use this when I simply want to compare 2 dates that are already stored in a table.
But we have additional use cases where we want to have fields that compare NOW with a date. For example:
What is the time difference between NOW and the opened date
What is the time difference between NOW and an upcoming Change
What is the time difference between NOW and a payment milestone on a project.
We've tried adding a few functions like NOW() into the glide function. The documentation doesn't explicitly say that other function fields aren't supported.
So we were wondering if there was any way to achieve this type of comparison using the DateDiff feature itself?
I would anticipate that this type of calculation is a fairly fundamental and common use case for a lot of organisations.
