I've been working on this issue forever now...Here's what I'm trying to do. I have a custom list where people add some info. I crated 2 views to view items added today and yesterday. Now I'm trying to figure out how to create a view that will always show items added last friday no matter what day of the week I look at the view... I tried following and it didn't work for me:
- Filtered "Created" column where it =[Today]-3, which didn't work because I can use it only on Monday
- Filtered "Created" column and used following formula:
this formula always gave me "Filter Value is not in supported date format", so i tried using "text(above formula,"mm/dd/yyyy") and it didn't work either
- Because of the format I decided to create an extra column that simply converted "Created" into text...so =Text([Created],"mm/dd/yyyy"). And then I tried to filter newly created column with the above formula...it didn't work...
- I tried using another formula in the filter, and got another date format error...However, I like this formula the best as it pretty much checks for day for the week, and if it's not Friday, than does calculation...
Thank you in advance for your assistance and ideas.