Subtracting two dates in DB-folder using formula-column

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?

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.