Bubble.io Date Filter: Last Month
Learn how to filter a list of dates to only show entries from last month in your Bubble.io app with this tutorial.
Filter dates like a pro: Learn how to target last month's entries in your Bubble database with this simple tutorial!
Unlock the power of date constraints: Discover how to create dynamic date filters in Bubble without complex coding.
Master time-zone relative filtering: Elevate your database queries with advanced date filtering techniques in this must-watch video.
Introduction to Date Filtering in Bubble.io
In this Bubble tutorial video, I'm going to show you how we can filter a list of dates to only show entries in our database where a date field is last month. But before I do that, if you're building a Bubble app, you're building a no-code SAS application, click the link down in the description because we've got hundreds of Bubble tutorial videos just like this one.
Understanding the Concept of Last Month
So yeah, last month. I'm going to begin by building an expression in a text field here because that's going to just show you what's going on behind the scenes. We need to sandwich a date field between a start date and an end date.
Creating the Start Date for Last Month
So the start date of last month we would arrive there by going something like current date to time month, add months, minus one month. So today's May 8th, that's going to take us to April 8th. Then we need to round it down to month. Notice that this is all time zone relevant, relative, time zone relative.
Previewing the Result
Let's preview that. So we should hopefully see April 1st. There we go, midnight April 1st.
Implementing the Date Filter in Bubble.io
So on our events or our calendar, we can say date is greater than and let's get our April 1st expression in there, current date time, month plus months minus one, round it down to month.
Adding the End Date for Last Month
Okay, but now what if we've got events in May, my current month? So we would say date, come back, is less than and now we need the start of the current month. Well I think you can guess how we get there. So we say current date time, round it down to month.
Conclusion
Okay, there you go, that's how you can target last month in Bubble with date filters and date constraints.
Can't find what you're looking for?
Search our 300+ Bubble tutorial videos. Start learning no code today!
Flexible Pricing Plans to Fit Your No-Code Journey
Choose the plan that aligns with your goals and start building your startup today.
Have questions?
We have answers!
Find answers to common questions about our membership plans, programs, and more.
Both plans offer full access to our learning resources, community, and support. The Annual plan provides a significant discount (over 15%) compared to paying monthly, and it allows you to lock in your rate for a full year.
Absolutely! You can easily upgrade or downgrade your membership plan at any time by logging into your account and selecting the desired plan. Any unused portion of your current plan will be prorated and applied to your new plan.
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.
If you decide that Planet No Code isn't the right fit for you, you can cancel your membership at any time by logging into your account and navigating to the subscription management page. Click the "Cancel Membership" button, and your membership will be terminated at the end of your current billing cycle.