Filters Not Updating Daily

[MBB]

I have encountered this behaviour as well, when using Today() in formulas and filters, it would sometimes use the wrong date, sometimes by up to a few days.

Why is Today() is not updating?

I have a document in which users can make reservations for certain equipments. I need a lookup column of all reservations which are for Today(). If I expand the formula, I get the appropriate results, but the table itself does not update. In this example today is feb 23 but it is showing feb 18, therefore the lookup is showing the reservations from feb 18 instead of today. refreshing the page does not resolve the issue [img01] [img02] thank you for all suggestions or workarounds