# Show aging.. or how old an item is

**URL:** <https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465>\
**Category:** Ask for Help\
**Created:** [February 9, 2021, 5:26am UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465 "2021-02-09T05:26:45Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_O](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_o/32/21282_2.png) [@Daniel\_O](https://community.glideapps.com/u/Daniel_O)\
**Post date:** [February 9, 2021, 5:26am UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/1 "2021-02-09T05:26:45Z")

</div>

I want to show in my app how old something is from the current date. I plan to have a list of items that a user adds, and then I want to show how long ago it was added (2 days ago… etc.).

My husband owns a small trucking company, and drivers get paid a week after submitting their deliveries. So I would like to have a view to show which deliveries are ready to be paid out by showing which ones are over a week old.

At least, that is my plan.

This is my first time using glide, so I’m fairly new, but I’m excited at what glide can do for our small business.

I really appreciate any help you can provide.

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [February 9, 2021, 5:34am UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/2 "2021-02-09T05:34:52Z")

</div>

1. Log the current time when adding items using the special value: current date/time.
2. Create a math column to calculate the difference between this date and now.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 9, 2021, 5:38am UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/3 "2021-02-09T05:38:48Z")

</div>

> [@Daniel\_O](#):
>
> My husband owns a small trucking company, and drivers get paid a week after submitting their deliveries.

Assuming you have all your deliveries logged in a table - let’s call it “Deliveries”:

- add a datetime column to your Deliveries table
- whenever a delivery is submitted, update that column using the special value “current date/time”
- then all you need is a simple math column to compare the delivery date to the current date/time

It might look something like this:

 ![Screen Shot 2021-02-09 at 1.38.18 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d24d3fb41109556b5b470241fa0ac7ad47e194ab.png)

---

<div class="post-metadata">

**Author:** ![Daniel\_O](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_o/32/21282_2.png) [@Daniel\_O](https://community.glideapps.com/u/Daniel_O)\
**Post date:** [February 10, 2021, 12:55am UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/4 "2021-02-10T00:55:16Z")

</div>

Thank you so much! This worked out great. There is so much Glide can do I’m just now starting to wrap my head around it.

---

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [May 18, 2022, 8:06pm UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/5 "2022-05-18T20:06:30Z")

</div>

Hi, how to get the NOW date? I dont see function or constant to get the NOW date.  
Thanks!

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [May 18, 2022, 8:12pm UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/6 "2022-05-18T20:12:48Z")

</div>

Now is one of the values of the math column.

> **[Math Column](https://docs.glideapps.com/all/topics/computed-columns/primary/math-column#date-and-time-math)**
>
> Performs instant calculations on your data

---

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [May 18, 2022, 8:37pm UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/7 "2022-05-18T20:37:06Z")

</div>

Thanks, I ddnt realize you can type here lol, been searching how to get the NOW as it is not autofilter/populate.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c81214680642a311f3705eb25657657e1ec6fc4.png)

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/show-aging-or-how-old-an-item-is/22465/8 "2024-01-17T16:49:36Z")

</div>


