I need help in calculating Fiscal year for given Date. My fiscal year begins on Oct 1st of every year and I also need to calculate Fiscal Day number of year,
EX: if Date in table is 2010-10-5 then my fiscal year start date should be 2010-10-01 and in my next column I should get day of year as 5
any help is greatly appreciated.
View Complete Post