Been bubbling for a while and encountered a problem filtering dates that feels like it should have a much more elegant solution than the ones I’m using. Other posts I found felt too app-specific, so I’m hoping this can be a more general resource. The issue stems from the way dates are always stored as both a calendar date and a specific time. In a personal habit tracker I’m making, finding all instances of a habit logged TODAY requires some pretty complex filtering because “created date = current date” is trying to match the time down to the millisecond, not just the calendar date. Solution 1 was to just format the created date and current date/time as texts. That drops the time and matches the date as you’d write it on a check or document. Seems to work and can’t think of a situation that will create problems later. But I did encounter a weird problem with my original solution, which was to extract the date from the created date and the current date/time and try to filter to find matches. January worked great, but once February rolled around, I was including old January things in the filter. It’s because the extract date sees January 2nd and February 2nd as the same — 2=2. In hindsight it makes sense, but I imagine this issue might drive others crazy in the future, so I wanted to share my experience. Plus, I realized that I’d encounter a similar problem next year for my habits that track weekly and monthly. Once January 2023 rolls around, my January 2022 things will show up in the filter again because, of course, 1=1 when you extract the month. Solution 2, then, was to just add another line to the filter that extracts and matches the year as well. I can’t imagine why that wouldn’t work long term, but it still strikes me as very complex just to filter for things that happened this week or this month. Easy to say, hard to code, I guess? Other solutions I found in the forum involved lots of inequalities and rounding the date, but these seemed even more complicated. Maybe I’m missing something that’s obvious to professional coders, though? I tried to learn how to code many times over several years, but I failed every time. Only Bubble was able to put it within reach and make it all very logical to me. This date filtering issue seemed like a weird place where coding rules still trump common sense, though. Anyway, hopefully this helps someone who’s just getting started! Other thoughts and solutions welcome and appreciated.

[image] mike.settele: The issue stems from the way dates are always stored as both a calendar date and a specific time. No, dates are just the latter — a specific point in time. Here’s a good primer/introduction to the dates in Bubble (also applicable to JavaScript as they are the same thing): [image] Live Bubbling with Keith: Let's Talk About Dates - Explaining the Basics of Dates in Bubble Tips Been a while since I posted a long-form video… Here’s a new 1 hour video where I talk about the basics of the much-misunderstood Date data type in Bubble. Covering what dates are and why we need them, explaining that dates are times, explaining the difference between date construction and date formatting, and showing the new “Utility” features in Calendar Grid Pro. This might be helpful to anyone who has struggled with dates or who wants a better understanding of the basics of dates. Also, I n… You can find a lot more info about dates by searching @keith and dates here in the forum.

Thanks, Keith! I think the beginning of your video is saying the same thing that I was trying to. To a layperson, a date is just the calendar date, like February 13th. Bubble thinks about dates differently, which makes total sense in hindsight. But as someone who’s Bubbling without any background in coding, the required mental change took a bit of time. A lot of the forum posts that I found on dates seemed to involve the same confusion, with a bit of talking back and forth before everyone got on the same page. If we’d all seen your video, it would have saved a lot of time!

Date Filtering Best Practices?

Need help App Organization

keith February 4, 2022, 3:07am 2

No, dates are just the latter — a specific point in time. Here’s a good primer/introduction to the dates in Bubble (also applicable to JavaScript as they are the same thing):

You can find a lot more info about dates by searching @keith and dates here in the forum.

Topic		Replies	Views
Struggling with extract:date Database	0	229	November 6, 2022
Date only (not time), into the database Need help	18	6582	March 10, 2021
How to constrain only by date, not date and time? Need help	19	4267	July 9, 2021
Filtering based on date only, not time Need help	6	1723	September 16, 2021
An "Easy" Way to Convert Bubble Date/Times to the Same Date, but in a Different Timezone Tips	34	12166	November 3, 2023

Date Filtering Best Practices?

Related topics