Hey @fayewatson: As for checking for an end-of-day that has not happened yet, and is a condition that will never be found true, do not feel bad!:
Since the only arbitrary date we can create in Bubble starts with “Current Date/Time”, this concept is often used as a proxy for “arbitrary date”. So your example, where you’re TRYING to say, “Well look, if you have date1 and you wanna make sure it happens on date2, IN A CONDITION… you have to check if date1 happens AFTER the start of date2 and BEFORE the end of date2” your second example is correct… if we replace “Current Date/Time” with “date2”… but Bubble makes it hard for us to quickly make such a screenshot, yeah?)
I’ve written that exact same example for folks and then had to backpedal a bit, saying “Well, duh, we don’t have to check for the future date, but you get what I mean.” And invariably, of course, the noob user does not know what we mean.
As for your follow-on question: Doing datewise comparisons will always make things correct. So, if we have an RG displaying Posts bounded by “Current Date/Time” as the most recent Post, back to Current Date/Time+(days) -1 (which I’d do as Current Date/Time+(hours) -24)… Those are both specific moments in time (“now” back to 24 hours before “now”). They are dates – dates are specific moments in time. These are the same for everyone everywhere.
Problems only arise (and they are not problems, but gaps in our understanding of what specific moments in time ARE) when we try to REPRESENT dates (for example by rendering them as text). This is why I cringe when I see people saying stuff like “only if it happened today”… Well, that’s open to interpretation… also, that’s arbitrary. Vague + arbitrary = stupid. It’s a stupid constraint and there’s no need for ever doing that.
In this context, for example, the OP is… well, I have no idea why they’d want to do this. They are just trying to show “stuff that happened recently”. But why limit the “back in time” point? The list of posts should simply be an RG of posts, of style vertical scroll ext, sorted by Created Date descending. LET THE USER DECIDE when they stop scolling. Done.