Date Math Displaying as Hours Instead of Days

[BLA_68]

I’m trying to do exactly what is depicted here:

Date-time Math

Date-time math (e.g. DATEDIFF) is one of the most common Google Sheets formulas that people still rely on in their Glide apps, but as many of you know, relying on Google Sheets formulas can slow down your app, as Glide must wait for your Google Sheet to update, and then for Google to tell Glide about it. When you do your date calculations in Glide, they update instantly! Here you can see how we use this capability in one of our internal apps to calculate the age (in days) of ideas on our backl…

But instead I get this result:

There is no option to configure the display. Any hints on what I’m doing wrong?

[Darren_Murphy]

The behaviour of this was changed recently. Subtracting one date from another now gives a duration. To get the result as an integer (days), you need to use either round() or trunc() in your formula.

eg. round(now-date)

[BLA_68]

Thank you!