Display data by fiscal year instead of calendar year

• Robert-378556

  SSCertifiable

  Points: 5917

  More actions

  August 16, 2012 at 3:06 am

  #1526410

  You can make those huge case expressions much simpler, shorter, easier to maintain....

  'FY ' + cast((YEAR(Registrationdate) + MONTH(Registrationdate+2)/12) as varchar(10)) as FY,

  (MONTH(Registrationdate)+3) % 12 as FYMonth

• GPO

  SSCarpal Tunnel

  Points: 4574

  More actions

  September 7, 2012 at 1:54 pm

  #1535273

  There are four things to take away from this thread.

  1. Celko is right.

  2. Celko has a few runs on the board. He's better qualified to comment than most.

  3. A calendar table is like sex. If you're not loving it, you're not doing it right.

  4. If in doubt, see point 1.

  ...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell