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.