# Is it possible to automatically show today's record based on month and day? **URL:** \ **Category:** Ask for Help\ **Created:** [March 10, 2026, 2:46pm UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619 "2026-03-10T14:46:49Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Lies\_Die\_Bibel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lies_die_bibel/32/80029_2.png) [@Lies\_Die\_Bibel](https://community.glideapps.com/u/Lies_Die_Bibel)\ **Post date:** [March 10, 2026, 2:46pm UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619/1 "2026-03-10T14:46:49Z")
Hello everyone, I’m trying to build a simple devotional app in Glide and I’m wondering if the following use case is possible. I have a table called **“Andachten final”** with **366 rows** (one for each day of the year, including Feb 29). Relevant columns: - `month_num` (1–12) - `day` (1–31) - plus the devotional content Example: | month\_num | day | title | | --- | --- | --- | | 1 | 1 | SEGEN | | 1 | 2 | TRIUMPH | | 3 | 7 | … | What I want is very simple: The app should automatically show **the record for the current day**. Example: - March 7 → show row where `month_num = 3` and `day = 7` - March 8 → show row where `month_num = 3` and `day = 8` In other words something like: month\_num = current month AND day = current day I already tried several approaches with ChatGPT and Gemini (using things like Date/Time columns, Extract Date Part, relations, etc.), but I couldn’t get a reliable solution. Before spending more time experimenting, I wanted to ask: **Is this a supported/typical pattern in Glide, and if so what is the recommended way to implement it?** Thanks in advance! Patrick ---
**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:** [March 10, 2026, 3:21pm UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619/2 "2026-03-10T15:21:23Z")
- Create two math columns using the following: – `Month(Now)` : will give you the current Month number – `Day(Now)` : will give you the current Day (of month) number - In both cases above, use the special “Now” value as a replacement - Now create a Query column that targets your Andachten final table, and apply two filters: – month\_num equals This row → “first math column” – day equals This row → “second math column” - Ensure that your Query column does not have “Match multiple” selected - Finally, use a Lookup column to fetch the content for the matched day ---
**Author:** ![Federico\_Fleitas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/federico_fleitas/32/77461_2.png) [@Federico\_Fleitas](https://community.glideapps.com/u/Federico_Fleitas)\ **Post date:** [March 10, 2026, 7:13pm UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619/3 "2026-03-10T19:13:19Z")
Hi, I have experienced problems when using dates as a filtering measure, there is a video from @Robert_Petitto , where it provides a formula where it converts the date into numbers, to achieve exact filtering, Attached Formula: year(today)\*10000 + month(today)\*100 + day(today) ---
**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:** [March 10, 2026, 11:58pm UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619/4 "2026-03-10T23:58:10Z")
That’s not relevant in this case as date values are not being used as filters (numbers are). ---
**Author:** ![Federico\_Fleitas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/federico_fleitas/32/77461_2.png) [@Federico\_Fleitas](https://community.glideapps.com/u/Federico_Fleitas)\ **Post date:** [March 11, 2026, 10:58am UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619/5 "2026-03-11T10:58:16Z")
There is never more information that could be useful to another user 😉 ---
**Author:** ![Lies\_Die\_Bibel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lies_die_bibel/32/80029_2.png) [@Lies\_Die\_Bibel](https://community.glideapps.com/u/Lies_Die_Bibel)\ **Post date:** [March 12, 2026, 12:31pm UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619/6 "2026-03-12T12:31:48Z")
Thank you very much. You solved what ChatGPT and Gemini coulnd´t. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 19, 2026, 12:31pm UTC](https://community.glideapps.com/t/is-it-possible-to-automatically-show-todays-record-based-on-month-and-day/86619/7 "2026-03-19T12:31:53Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.