Dates in rows

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.

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.

1 Like


Do you mean something like this?

I’d start with zero if you want to include today, but yes exactly like that.

1 Like

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.

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.

1 Like


There is something very curious that is happening to me, it is that the days are repeated, for example the 5th

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!

2 Likes

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