Bubble.io Date filter: Yesterday
Learn how to filter dates in Bubble.io by yesterday in this Bubble tutorial video.
Master Bubble date filtering: Learn how to target yesterday's events with precise date constraints in your calendar app!
Unlock powerful date filtering: Discover the secret to filtering events by specific date ranges in Bubble, including yesterday's data.
Elevate your Bubble skills: Transform your calendar app with advanced date filtering techniques for pinpoint event targeting.
Filtering by Yesterday in Bubble.io
I was recently helping a Bubble app builder in a Bubble coaching session filter by dates in the application and it can be a little bit tricky. So in this Bubble tutorial video, I'm going to demonstrate how we can filter by yesterday.
Setting Up the Calendar
I've got a calendar here at the moment. It is searching for all events and it's just going to return all events. Then I've got two printouts of dates here in order to show you what's exactly going on behind the scenes.
Joining Our Community
But before I launch into that, if you are learning Bubble, if you want to launch a no-code SaaS, then there's no better place to do it than clicking the link down below and joining our community and accessing all of our videos through our website.
Targeting Yesterday's Date
In order to target yesterday, we need to sandwich a date field between "is it greater than this date" and "is it less than this date". So let's begin by getting the start of yesterday.
Getting the Start of Yesterday
I can say current date time and then I could say days minus one and then round it down to day. Let's see how that prints out. So today's date is May 8th, and there we go, we're going back to the start of yesterday.
Getting the End of Yesterday
Now how do I get the end of yesterday? Well, I could - and this is going to be using the equal to or greater than and less than operators, so this would be perfect. I can just say rounded down to day.
No Need for Subtracting a Second
Now you might think strictly I'd need to then minus one second off it, but no, you don't. This is going back to the very start of today, which is the moment after yesterday finishes, of course.
Applying Constraints
So in applying this to some constraints here, I can say date is equal to or greater than, then I need the start of yesterday which is current date time days minus one rounded down to day. Okay, so that's midnight the start of yesterday.
Setting the End Constraint
But then the end of yesterday is just less than, so it's not equal to or less than, it's just less than midnight today. So current date time rounded down to today.
Conclusion
Okay, so that's how you would create a constraint on some date fields to target events that only happen yesterday in your Bubble.io app.
Get the Complete Bundle for Just $99
Access 3 courses, 390+ tutorials, and a vibrant community to support every step of your app-building journey.
Start building with total confidence
No more delays. With 30+ hours of expert content, you’ll have the insights needed to build effectively.
Find every solution in one place
No more searching across platforms for tutorials. Our bundle has everything you need, with 390+ videos covering every feature and technique.
Dive deep into every detail
Get beyond the basics with comprehensive, in-depth courses & no code tutorials that empower you to create a feature-rich, professional app.
Save over 70%!
Valued at $80
Valued at $85
Valued at $30
Valued at $110
Valued at $45
Can't find what you're looking for?
Search our 300+ Bubble tutorial videos. Start learning no code today!
Have questions?
We have answers!
Find answers to common questions about our membership plans, programs, and more.
We're here to help you launch your no code SaaS. Reach out to the team and we'll double check our vast library for useful content. We'll advise you on how we'd tackle the same problem and there's a good chance we'll record the video to help the wider community.
As a Planet No Code member, you'll receive a discount on our Bubble coaching sessions. Monthly members receive a 10% discount, while Annual members receive a 17.5% discount. To redeem your discount, simply log into your account and book a coaching session through our platform.
Our 8-week intensive mentorship program is designed to provide personalized guidance and support to help you accelerate your startup journey. You'll be matched with a startup expert who will work with you one-on-one to set goals, overcome challenges, and make rapid progress.
To apply for the Mastery Program, simply click the "Request Invitation" button on our pricing page and fill out the application form. Our team will review your application and schedule a call with you to discuss your goals and determine if the program is a good fit for your needs.
We accept all major credit cards, including Visa, Mastercard, American Express, and Discover.
While we don't offer a free trial, we do provide a 14-day money-back guarantee. If you're not completely satisfied with your membership within the first 14 days, simply contact our support team, and we'll issue a full refund.