How to filter Event dates by week in Bubble

Quick Tip for Working with Dates in Bubble

Here's a quick tip when working with dates in your Bubble app. In this Bubble tutorial, I'm going to demonstrate how you can work with weeks, particularly if you want to be filtering events or date data in your Bubble app by week. I'm going to be demoing this with this calendar I've got going here, and basically I'm going to create a series of events and I want only the events in the current week to show up in this repeating group.

Join Our No-Code Community

But before I launch into that, if you're learning Bubble there's no better place to do it than joining our community over at PlanetNoCode.com where we've got hundreds of Bubble tutorial videos. We release more videos every single week, so like and subscribe this one if you're watching on YouTube. And yeah, that's the great place to join and to learn no code and learn Bubble with other people just like you.

Demonstrating the Challenge

Let's dive into this demo. So let me first of all highlight what's frustrating. If I go into search for events at the moment based on this previous demo I've got, but so right clear it out that's from an old demo, let's work with this. I want to be able to add a constraint about week and so I can go in and I can say date equals or date greater than less than. I mean there probably is a way to do that with constraints.

Extracting Week Data

The other thing I can do, which I'm just demonstrating but basically demonstrating how it doesn't help us but how you can get to week data, is that in the cell for an event I can go current cell as event date and then I can go extract and I can extract week. So that's going to be a week number assigned within the calendar calculations in the software.

Creating a Week Stamp

So if I refresh it we should see okay there we go so week five first week of February week six second week of February but if I go back into the constraints I can't take the extract value at this point. So this is my workaround if you've got a better way to do it please by all means reach out leave a comment but I effectively create a stamp. So I would say when we create the event I'm going to add in a field I'm gonna make a text field not going to call it text I'm going to call it week stamp and then what I'm gonna do is say the date but then format it as custom and I found that this works quite well.

Formatting the Week Stamp

So if I was just to take out the week number and then my app was hugely successful and I'm still working on it in a year's time then that's not enough because the dates in week five of next year would appear alongside dates in week five of this year. So that's why I started with the Y's that stands for year we can see a preview down here what it looks like and then I put a hyphen and I put WW and so that is meaning it takes the week number and if it needs to it puts a zero before it and the reason for doing that is so that if I wanted to I could sort them alphabetically and then they would actually in fact be in order.

Using the Week Stamp for Filtering

Now I've got that field in place I can go back and search my events and I can add a constraint and I can say week stamp equals and I just generate the current date times week stamp in the same format as I've just done. So remember YYYY-WW so it's going to look for an exact match with the data. Now the two events I already have in the calendar I need to delete those because they're missing that week stamp data.

Testing the Week Stamp Filter

Where am I working? Yeah preview. So let's add in an event the demo one and it's going to be this week let's say tomorrow create event and it shows up but let's add in an event for next week and it shows in my calendar because I'm not constraining it by my week stamp but it doesn't show it in my repeating group.

Conclusion

So there you go, that's one way that you can apply a filter for a week is to create a text stamp with the year and the week number remembering the week number needs to be two digits otherwise if you then rely on it being an alphabetical order it's not going to work so well. But yeah, there you go that's how you can work with weeks better in Bubble. If you've got any other tips working in dates or any other questions for working with dates in Bubble please do reach out to us and we'd love to hear your feedback.