In table chart, compare datetime values with current datetime

[sasa]

Hello,

It would be better if we can compare date field with “current date and time” in chart and display time between them.
There are many use cases. For examples…

1. Show how many days until due date
2. Show records which are unchanged for some time
3. Show list of devices which exceed next inspection date

What does it sound?

[canaalpaslan]

Hey @sasa,

I am excited to share that we have CurrentDateAndTime() function in the Expression Editor in Analytics where you can actually compute this, you should be able to do all of the examples you have listed. Feel free to give it a try, and let me know if you have any questions.

Best,
Cana

[sasa]

Thank you for the information. I should have checked the thread before posted it.

Looking for a way to reference the current Date/Time in an analytical dashboard

Hello, we have a usecase here where we would like offer a dashboard based on a Tulip table which references the “current date/time” of when the analysis was last updated. Is this already possible? I could not find any reference in the expression editor or anywhere else. Example application: show time left from now till the value specified in a date/time column of a tulip table. [image]