I am working a column that has dates and I am trying to do the following:
1. Display: I have selected the "week" option of displaying the dates of the current year, but it's showing the first of the week (Monday's Date) vice the last week of the week (Sunday's Date). How can I change the display to show what I need?
2. Sum of the Week : How can I calculate the sum of the sales column based on a week's worth of calculation (MON to SUN)?
Looking forward to your response.
For part 1 - let's call it Sunday Date
Dateadd('day',6,[Date]) should do the trick, it adds 6 days to the date calculation.
For part 2:
If datediff('week',[Sunday Date].today())=0 then sum([Sales]) end