I am trying to calculate a year to date sales total based off of our fiscal year. Our fiscal year runs from 10/01/yyyy to 9/30/yyyy. My problem is writing the T-SQL that will do the date conversions. Here is an example of what I mean: if I were to want to get the sales totals for the current fiscal year up to todays date I would need to pull data from 10/01/2008 through today (getdate()). So I understand that I would have to take the YEAR of GetDate() and subtract one from it. But here is where/what I'm not understanding...what happens when the fiscal year is between 10/01/yyyy and 12/31/yyyy of the same year? If I use the same code the get the YEAR I'm going to be getting the previous year. Do I need a CASE statement of an IF statement? I'm kind of lost here, any help and direction would be great.....Thanks!