# Extract the last date

**URL:** <https://community.glideapps.com/t/extract-the-last-date/75600>\
**Category:** Ask for Help\
**Created:** [August 12, 2024, 11:33am UTC](https://community.glideapps.com/t/extract-the-last-date/75600 "2024-08-12T11:33:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Camille1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/camille1/32/56100_2.png) [@Camille1](https://community.glideapps.com/u/Camille1)\
**Post date:** [August 12, 2024, 11:33am UTC](https://community.glideapps.com/t/extract-the-last-date/75600/1 "2024-08-12T11:33:55Z")

</div>

Hello,

I need your help because I have a table of tasks and every week the customers need to do the same tasks.

I want to put the difference between the last date and now on my layout. (I know how to do a difference between dates but when I do it it’s for all the dates but I only want the smallest)

Thank you.  
Camille

---

<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:** [August 12, 2024, 12:08pm UTC](https://community.glideapps.com/t/extract-the-last-date/75600/2 "2024-08-12T12:08:12Z")

</div>

To get the latest date from a table, you can use a rollup column, and select latest.