# I can't get list to show results when I filter by "Date" "Date & Time"

**URL:** <https://forum.adalo.com/t/i-cant-get-list-to-show-results-when-i-filter-by-date-date-time/41153>\
**Category:** Get Help\
**Created:** [August 8, 2023, 1:18pm UTC](https://forum.adalo.com/t/i-cant-get-list-to-show-results-when-i-filter-by-date-date-time/41153 "2023-08-08T13:18:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt1](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Matt1](https://forum.adalo.com/u/Matt1)\
**Post date:** [August 8, 2023, 1:18pm UTC](https://forum.adalo.com/t/i-cant-get-list-to-show-results-when-i-filter-by-date-date-time/41153/1 "2023-08-08T13:18:53Z")

</div>

Hi guys,

I’m creating a view, where users can see the Activities they performed each day.  
I’ve made a list for each day, but have problems displaying the Activity from the database, thats from yesterday and back.

I want to allow users to registre an Activity back in time, so I cannot use the “Create Date” as the activities will show on the day they where created by the user and not the not on the date set by the user. (See example here)

 ![Skærmbillede 2023-08-08 kl. 15.06.40](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/e/b/ebffc12f6fcab7c3284ea7f7af49c4d2174fc89d.png)

 ![Skærmbillede 2023-08-08 kl. 15.04.51](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/1/3/13060234e817d56f3184f75072521adb9f18db5e.jpeg)

When I use “Data & Time” or just “Date” instead - filtering between “Start of today” and “Current time” I get data back from today.

**The Problem**  
But ones I set this filter to be between “1 day ago” and “Start of today”, I get no data back.

 ![Skærmbillede 2023-08-08 kl. 15.37.15](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/6/6/66cbb856aaefef7746b69016ac823655f4d33fb6.png)  
 ![Skærmbillede 2023-08-08 kl. 15.35.26](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/9/8/98cbc711018536cc6d8057b9efa56acd566491bd.png)

I also tried to create a number field and a text field on the Activity and save the create date as text or numbers, but filtering on that field also doesn’t give me a result back.

 ![Skærmbillede 2023-08-08 kl. 15.08.47](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/7/875fc70aae2d01359b508f228ca659e2bd94ea74.png)

Please let me know if you can tell me what I’m doing wrong 🙂

Hoping for a simple solution tapping in to these existing filters to avoid a solution that is heavier on the database than it has to be, as I already have a lot of actions and records 🙂

Thank you 🙏

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [August 18, 2023, 1:19pm UTC](https://forum.adalo.com/t/i-cant-get-list-to-show-results-when-i-filter-by-date-date-time/41153/2 "2023-08-18T13:19:22Z")

</div>

Closed on August 18, 2023, 1:19pm UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.