I want to create a rather simple view in a SharePoint Online list, but I'm having trouble with the expressions and logic. The list is a project report in which the info of all received project requests is entered daily.
I want to have a view that only shows projects entered during the last day, i.e. the latest report. I could do [Today] - 1 in a filtered view, but that breaks on weekends and Mondays, and if the user is accessing the list on the same night of a shift (they'd always see yesterday's report), I think the best way is to show elements from the most recent day, but I'm not sure how to go about doing that.
If SharePoint allows a more complicated logic in a filtered view, I haven't been able to find information on the right syntaxis, because nothing I've seen online (like using logic with WEEKDAY and similar functions) and applied to a filtered view seems to work.
Any help is much appreciated. I'm sure this can be accomplished and that I'm missing something basic (fairly new to the SP world).