Function to get 2 dates

[techgnome]

by using a case statement and the datediff function...

case 
  when getdate() < convert(datetime, convert(varchar(4), year(getdate()) + '-09-01') then  convert(datetime, convert(varchar(4), (year(getdate())-1) + '-09-01') 
  else convert(datetime, convert(varchar(4), year(getdate()) + '-09-01') 
end as startDate

for the end date, it's similar logic... just change the 90-01 to 08-30 (I think you meant the end of august, not the end of September, otherwise you end up with an overlap.

-tg

[venerable bede]

I take it I can wrap this up in a function.
I'm not in work at the moment but I'll mess around with this tomorrow but 'm stil not sure why I need CASE.
Thanks for that.