# Display only entries of the last 3 days

**URL:** <https://community.glideapps.com/t/display-only-entries-of-the-last-3-days/36328>\
**Category:** Ask for Help\
**Created:** [December 24, 2021, 3:47pm UTC](https://community.glideapps.com/t/display-only-entries-of-the-last-3-days/36328 "2021-12-24T15:47:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Christian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christian/32/19289_2.png) [@Christian](https://community.glideapps.com/u/Christian)\
**Post date:** [December 24, 2021, 3:47pm UTC](https://community.glideapps.com/t/display-only-entries-of-the-last-3-days/36328/1 "2021-12-24T15:47:54Z")

</div>

Hi everybody,  
I would like to create a tab where only the newest entries from the last 3 days will be shown from 4 other databases after another (with 4 different inline-lists).

How can I build this filter, I assume with a new math-column something in the formula like  
" today - create date" and than setting a filter on that?

Or is there a chance direct with filter & date . . …“is on before” something…

THX

and by the way: Happy Christmas from Hungary 🙂

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 24, 2021, 3:52pm UTC](https://community.glideapps.com/t/display-only-entries-of-the-last-3-days/36328/2 "2021-12-24T15:52:04Z")

</div>

I think you have the right idea with a math column. Do the math in each table of data that you want to show on the tab. It will give you a number of days difference between the creation date and Now. Then you can set your filter on the inline lists to show rows where the day difference is less than or equal to 3.

---

<div class="post-metadata">

**Author:** ![Christian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christian/32/19289_2.png) [@Christian](https://community.glideapps.com/u/Christian)\
**Post date:** [December 24, 2021, 7:58pm UTC](https://community.glideapps.com/t/display-only-entries-of-the-last-3-days/36328/3 "2021-12-24T19:58:08Z")

</div>

Could you provide me with the formula? I never done that before …  
THX

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 24, 2021, 8:41pm UTC](https://community.glideapps.com/t/display-only-entries-of-the-last-3-days/36328/4 "2021-12-24T20:41:11Z")

</div>

‘N-D’ or ‘Now-Date’ will work in a math column.

Replace N or Now with Now.  
Replace D or Date with whichever date column you want to compare to.

The result will be the number of days difference between the dates.

---

<div class="post-metadata">

**Author:** ![Christian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christian/32/19289_2.png) [@Christian](https://community.glideapps.com/u/Christian)\
**Post date:** [December 25, 2021, 10:45am UTC](https://community.glideapps.com/t/display-only-entries-of-the-last-3-days/36328/5 "2021-12-25T10:45:58Z")

</div>

Hi Jeff, Thank you very much, that`s abolut helpful.