How do I create date dynamic content in an efficient way?

Need help Database
1

Let’s say I have a news item of the day, and the content changes on my page according to the mm/dd/yy (also how do I avoid getting caught up with timestamps?) where I pull some data out of my content table according to what day it is? Don’t want to kill my utilization or whatever so what’s the most efficient way to do this? How do I do this? New to Bubble and apologies if this has been asked before. Please be gentle.

2

Wow, nobody? Even if you point me to something that addresses this…

3

you can just filter what you need to show based on the current date and your desired news data date

4

This answer was not helpful, sorry.

5

I assume your news items have the correct created dates (which are actually date time). So when you search, you need to bracket the created date time by the start of current date and the start of next date.

For example, assume news1 was created on 9/10 11AM. You search on news where the created date >= 9/10 12AM and created date < 9/11 12AM.

Use the current date:extract date and current date:extract date:+day:1 (or something like that) to get those 2 dates.

6

I think filter your search:

  • date <= Current date/time :rounded down to days +days -X
  • (search only on the X days before today)

And then use the :groupby feature:

  • field to group by: creation date
  • type of grouping: day
  • interval: 1
  • starting date: no matter if you already filter your search

I think this may be the most efficient way to display the news of today on your page (and those from past days group by day in another section if you ever want to)