Time difference between last record and now()

Hi. Is there a way in InfluxDB to get last record and calculate time difference from now()? Elapsed function not really works for me as I only need to know how long there are no new records at current moment.

I was trying to use “now()” in “select” part but got error: InfluxDB Error: undefined function now()

Please use this to calculate the difference.

Thanks! Unfortunately my datasource in Grafana allow to use InfluxDB only, can not switch to Flux