How to use the notes' modified time property in a formular?

What I’m trying to do

I’d like to add a column shows the number of days between today and the the date that a note is modified.

i can see the later as a property being shown as a column.

Things I have tried

in fomular editor, i can get the date of today using today(), however i don’t know how to get the note’s modified date.

If you don’t have a modified key (or alike) in the properties of your notes in which you store the “last modification” date/time of said notes, you could try to use file.mtime :blush:

file.mtime - today()

(or something similar, depending on your use case :innocent: )

Ah, I see! I hadn’t thought of that, thanks.