Hi all,
I’m using Glide Apps (not Pages) and building a treatment reminder system. I need to filter records based on whether a reminder date is today, within 7 days, or within 14 days, etc.
The problem is:
There is no “Current Date/Time” special value available in Glide Apps.
I can’t find a reliable way to dynamically compare a column to “today”.
I want the comparison (e.g. Reminder Date is within next 7 days) to update automatically each day, without needing a manual update or editing the row.
Is there any workaround or trick to get the current date/time in Glide Apps — perhaps from the user’s device, or some automatic method — so filters can stay up to date?
What do you mean by this? Glide Apps and Pages are the same thing. Classic Apps were the other product, but you can’t even work with those anymore, so I’m confident you aren’t talking about Classic apps.
Current Date/Time is available all over the place. When adding rows, you can capture the the current date/time at the time of submission. In a math column, you can use the Now value for the current date time. In an IF column, you can compare any date to Now or Today values. In filters you can compare to Now or Today values.
Where are you trying to do this comparison? Like I mentioned above, there are a lot of ways to do the comparison.
Depending on how you are trying to create the filter, you can use a trick, such as using a math column to add 7 days to a date and compare it to Now, or you can take the Now value and subtract 7 days to compare it to a date.
Like I said, access to current date and time as a dynamically changing value is available all over the place, but we need more information about what you are trying to do and how you are trying to set it up.
Thank you! Me and chatGPT managed thanx to your comment! I wish I could explain better, at my current understanding its way over my head at to write better question. Closing the topic.