Financial Year Calculation
Join the DZone community and get the full member experience.
Join For Freeselect (case when
datepart(mm,reqDate) between 7 and 12 then
datename(yy,reqDate) + '-' + datename(yy,dateadd(yy,1,reqDate))
else
datename(yy,dateadd(yy,-1,reqDate)) + '-' + datename(yy,reqDate)
end),
reqDate
from request
order by 1, 2
Opinions expressed by DZone contributors are their own.
Comments