Posted on 2009-07-10
I have looked around and couldn't find this.
I have a table with month date (mm/dd/yyy) and scores. I need to get the current quarter-to-date values. I think I'd have to get the datepart of the current month and then use an iif statement to figure out which (if any additional months) are needed.
Or is a preferred method to create a reference table with all the months and then code them by Quarter-to-Date values?