Slice Row Filter Condition Not Updating - Day Filter

[mjord24]

Hi all,

I have built a slice with the following row filter condition: AND([Day]=[Weekday Today],(TIMENOW()<[End Time]))

The time portion of the formula works great. My issue is that the day portion of the formula does not refresh automatically each day. In order to get the formula to update, I have to log into appsheet and either regenerate the app or re-save it.

Is there a way to have this filter condition update automatically?

Thanks in advance
-Michael

[Aurelien]

Hi @mjord24

What about:
AND([Day]=WEEKDAY(TODAY()),(TIMENOW()<[End Time]))