Only show results for Sunday
HI! I have a table that is updated daily. I need to create a report that will only show the results from the most recent Sunday. I need help! Thanks!
Forum Discussion
1 Reply
- If you need this custom filter on more than one report, then you should build a formula-field to determine if the [Date] value is the most recent Sunday.
If you only need this for one report, you can do this in a Report Formula so it only exists in the one report.
This formula assumes that your Application is set so that Sunday is the First day of the Week.
Formula-Checkbox:
If( [Date] = FirstDayOfWeek(Today()) ,true, false)
