Using dataview I can subtract two dates:
table without id
next_action, next_action - date(today) as time_till_next_action
from #todo
sort next_action
limit 5
Giving me the desired result:
How can I do the same using Database folder plugin.
This is my attempt:
Giving this (wrong) result:
The problem is that date(today) is not evaluating.
Any ideas?