1 of 1 people found this helpful
Thanks Shawn - I had actually tried that with DATEPART before... anyway with my way and your way the problem I was getting was that I was getting 0 results when applying the filter, which made no sense as I know there is data for this week. Seems the issue was that I had to apply the same DATETRUNC function to the actual date field used in the calculation to get it to work.
DATETRUNC('week', [date]) = DATETRUNC('week', TODAY())
Thanks for this!
Only issue left is that any days without schedules won't show up so it's not always a full Monday - Friday.