Using "current_date()" in custom field

[kerriu]

I would like to count the number of days that elapse between an event and the current date. When I use the below syntax in the custom field, I get this error: Unknown function "current_date"

diff_days(current_date(), ${timeclock_employee_hours.time_in_date})

Any idea how to get a custom field calculation to return an integer for difference between current data and timeclock event?

[Shru]

Try function now()

[blue1]

As Shru said, you can use now().

Just be careful, now() will return as the database timezone while ${timeclock_employee_hours.time_in_date} will can have a transformed timezone.

To get around that, set up a dimension "now" with type: date and the sql now() and then reference that dimension in your date_diff query. Then both dates will be converted to the appropriate timezone.