Forum Discussion
Solved
date filter skipping date!
So i have dates in a table which is basically fridays. Today im noticing that 6/20 somehow isnt being recognized when im doing this filter: 'is latest' works and picks up 6/27 which exis...
Add in the formula bar the following to your SelecxtRows():
or Date.IsInCurrentWeek([WEEK_END_DATE])I could not find a way to create the full filter using the dialog boxes: The advanced filter does not support Last 5 weeks and the basic filter does not support this week...
Add in the formula bar the following to your SelecxtRows():
or Date.IsInCurrentWeek([WEEK_END_DATE])I could not find a way to create the full filter using the dialog boxes: The advanced filter does not support Last 5 weeks and the basic filter does not support this week...
that was totally it.
Didnt realize i was in the current week and that it wouldnt get picked up under "previous" and "latest". Thank you!
