I want my report to show the first day of the week in the group headers for my Timestamp (which is grouped by week). My query is for the lastfullmonth.
If I put the Timestamp in the header, it just shows a random date in that 7 day period. Minimum brings the first day of the month.
totext(minimum(lastfullweek),"MM/dd/yyyy") brings the Sunday of the last full week from the data date.
How can I show the date of the first day of each week (Sunday)in my title? ex: "Week Starting 3/30/08"
Thanks in advance for any help you can give.
If I put the Timestamp in the header, it just shows a random date in that 7 day period. Minimum brings the first day of the month.
totext(minimum(lastfullweek),"MM/dd/yyyy") brings the Sunday of the last full week from the data date.
How can I show the date of the first day of each week (Sunday)in my title? ex: "Week Starting 3/30/08"
Thanks in advance for any help you can give.