# Dates in rows **URL:** \ **Category:** Ask for Help\ **Created:** [March 29, 2025, 2:51am UTC](https://community.glideapps.com/t/dates-in-rows/81048 "2025-03-29T02:51:49Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [March 29, 2025, 2:51am UTC](https://community.glideapps.com/t/dates-in-rows/81048/1 "2025-03-29T02:51:49Z")
Hello, good evening, colleagues. I hope you’re all doing well. I’m back, as always, on the trusted forum of one of the best builders at GlideApps. You know, I’m looking to do the following: I want to be able to display the days of the current month in the rows, for example. If it’s March 28th, then each row would have something like this: 03-28-2025 03-29-2025 03-30-2025 03-31-2025 And when the next April rolls around, it would start showing from 04-01-2025 and so on until the last day of the month. How complicated could this be? The idea is to display it in each row because I’m interested in using it as a filter later in a selection. ---
**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:** [March 29, 2025, 3:02am UTC](https://community.glideapps.com/t/dates-in-rows/81048/2 "2025-03-29T03:02:12Z")
Add an index column and number 0 through however many rows you need. Add a math column with the formula `now+x`. Replace now with Now. Replace x with the index column. ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [March 29, 2025, 3:04am UTC](https://community.glideapps.com/t/dates-in-rows/81048/3 "2025-03-29T03:04:48Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b1c73d05afebc2a9e43715276744202d384cb702.png) Do you mean something like this? ---
**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:** [March 29, 2025, 3:07am UTC](https://community.glideapps.com/t/dates-in-rows/81048/4 "2025-03-29T03:07:16Z")
I’d start with zero if you want to include today, but yes exactly like that. ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [March 29, 2025, 3:09am UTC](https://community.glideapps.com/t/dates-in-rows/81048/5 "2025-03-29T03:09:45Z")
Great, it works well. One question: How would you display only the dates from this month in a selection? I think I could have a filter where I have the last day of the current month and then make a filter that only shows me the days that are on that day or before that day. ---
**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:** [March 29, 2025, 3:11am UTC](https://community.glideapps.com/t/dates-in-rows/81048/6 "2025-03-29T03:11:16Z")
If you want to filter it to only the current month, make sure you have 31 rows, but add two more math columns. One to calculate `Month(now)` and one to calculate `Month(Date)`. If both numbers match, then those are the ones you want to display. ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [March 29, 2025, 3:15am UTC](https://community.glideapps.com/t/dates-in-rows/81048/7 "2025-03-29T03:15:51Z")
> [@Jeff\_Hager](#): > > If you want to filter it to only the current month, make sure you have 31 rows, but add two more math columns. One to calculate `Month(now)` and one to calculate `Month(Date)'. If both numbers math, then those are the ones you want to display. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e8a8d9969e4885301d203f4557c691a29ede2fe9.png) There is something very curious that is happening to me, it is that the days are repeated, for example the 5th ---
**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\ **Post date:** [March 29, 2025, 3:22am UTC](https://community.glideapps.com/t/dates-in-rows/81048/8 "2025-03-29T03:22:17Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c7cf1d4c2efc7bf04f3af69a6215afaa742f3c7.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd29de277a60457114d7fd5e6fa9a800e7752136.png) Thanks so much for that, Jeff! You’re a genius. With what you told me, I was able to put together exactly what you were suggesting, and then, using an “if” function, if the current number and the date’s number were the same, I’d bring in the dates. Thanks so much for your work! ---
**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:** [April 5, 2025, 3:23am UTC](https://community.glideapps.com/t/dates-in-rows/81048/9 "2025-04-05T03:23:00Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.