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.
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.
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!