🆕 Date-time Math

General
1

The Math column can now do math with date/times. In particular:

  • Subtracting two date/times produces a duration, which is a number and is measured in days, like in Google Sheets.
  • Adding a duration (number) to a date/time, or subtracting it from a date/time will add/subtract that many days to it.
  • You can pick “Now” as a substitution for a variable.

image
image1304×1334 73.6 KB

image
image1334×1184 115 KB

41 Likes
2

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 backlog:

image
image691×881 113 KB

19 Likes
3

Great!

5 Likes
4

This is a big one! Thanks for getting this done!

6 Likes
6

Let me quickly add a demo of this on my idiots guide :sweat_smile:

5 Likes
7

Hey @Wiz.Wazeer, do you share that guide of yours? I think it was written for people like me :joy:

3 Likes
8

Anyone can copy it @nathanaelb

2 Likes
9

@Mark @david This is really great, thank you.

3 Likes
10

Marvelous!

4 Likes
11

@Mark @david This is AMAZING! Thank you!!

2 Likes
12

If you have a link to the guide, I’d love to see it.

2 Likes
13

Fantastic!!! :star_struck:

Once I werent using formula in GS, now I can implement a lot a thing now! Thanks again guys!

1 Like
14
1 Like
15

Thanks so much! I need all the help I can get with setting up stuff like this. So cool that this feature is now available in Glide because I had just set up a DATEDIF function to track something. I just need help setting it up because it’s somewhat confusing for me on the Glide end.

4 Likes
16

YAAAAAAAAAAAAY!!!

Thank. You. Glide. Team!!!

9 Likes
17

Sweet!!! I am literarily working on a project now needing this. I was going to just do it in Google Sheets…but now…I won’t have to!!!

2 Likes
18

Oh my goodness this is the best news of September!

NOW!

I’ve been asking for this since September of last year it seems. You guys absolutely rock!!!

…now to update, well, ALL my apps :slight_smile:

7 Likes
19

Love that you can do Now + 1, etc. I smell increment button combos coming on to cycle through the details screens of daily events :wink:

3 Likes
20

Great idea!!! :bulb:

1 Like