New Bases: formula for date duration

Help
1

What I’m trying to do

I’m trying to get a column which show the “days until” a meeting in bases. I have a "scheduled_date property (of type “date”) and I’d like to subtract today’s date.

Things I have tried

I’ve tried with this code in a formula field:
($scheduled_date - date(today)).days

But I get no results (empty cell)
Can you help me?

2

I think this should work :blush:

scheduled_date - today()

… to get the difference between the 2 dates in milliseconds and this:

(scheduled_date - today()) / (1000 * 60 * 60 * 24)

or this:

(scheduled_date - today()) / 86400000

… should work to get the difference in days

3

Thanks @Pch it works perfectly! In the first the difference is expressed in milliseconds but the third return just an integer in days! Thanks again