Question
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!
This topic has been closed for replies.
+12If 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)
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)
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.