Why does my "Days Since Last Modified" Formula Not Work?

Vexir · June 24, 2026, 8:49am

SaaS

I created a Last Modified column in my table which populates just fine. I then created a Formula column with the following:

date_diff('days', field('Last modified'), now())

However, this only yields invalid number. Why is that?

picklepete · June 24, 2026, 10:05am

I think you’re looking for date_diff(‘day’, x, y) instead?

Cheers,

Peter

Vexir · June 24, 2026, 5:44pm

Hi Peter, I made the change but still getting invalid number.

olgatrykush · June 26, 2026, 10:58am

Hey @Vexir, have you tried debugging the formula with Kuma?

Kuma, our AI assistant, is pretty good at writing formulas.

picklepete · June 26, 2026, 12:19pm

Hello @Vexir,

I tried with a date and last_modified field:

Does that not work for you?

Cheers,

Peter

Vexir · June 27, 2026, 4:28am

Huh, that did work. I’m not sure why though - it’s exactly what I entered earlier! Oh well. Thanks!