Hello, good afternoon everyone. I’m back here. Yesterday, Jeff helped me implement the following:
I needed to have the days of the month present, so for example, if today is March 29, 2025
then it will show them in each row:
March 29, 2025
March 30, 2025
March 31, 2025
And so for the following months, where it will only show me the current month, I already achieved that. After that, I’ll show those dates in a selection.
But the following happens to me, when I select the choice with the dates already established from my table that I previously showed, then it only lasts a while and then is deselected, it is as if the selection is not fixed and I think it may be because of the format that I am handling the dates since the dates are added with the formula in the “Dates” column Now + x then because of the time change that Now is having, so that is why I think it is not left selected.
You are correct. A date column always has an underlying time and since that time changes every 10 seconds due to using ‘now’, you no longer have a matching selection. Try adding a template column to the choice table to lock in the date as text (without the underlying time). Then use that template column for your choice component. I think that should work.
There are other alternatives, such as splitting the date into separate Year, Month, Day columns and putting them back together…or using math to format the date as YYYYMMDD…but I think the template trick should work fine.
You’re right, the template column now takes those dates as “Fixed” and not with the time that caused me that inconvenience, as the time change produced that “deselection”. Thank you very much again Jeff! Saving me once again and learning every day with the Glide community <3
