How to get Current Financial months.

• chalam87

  Right there with Babe

  Points: 771

  More actions

  December 21, 2016 at 10:43 pm

  #332915

  Hi,

  i want to get current financial year months data, financial year starts from jul and ending jun.

  CREATE table #test(FinancialDate date)

  INSERT INTO #test

  VALUES

  ('2017-12-31'),

  ('2017-11-30'),

  ('2017-10-31'),

  ('2017-09-30'),

  ('2017-08-31'),

  ('2017-07-31'),

  ('2017-06-30'),

  ('2017-05-31'),

  ('2017-04-30'),

  ('2017-03-31'),

  ('2017-02-28'),

  ('2017-01-31'),

  ('2016-12-31'),

  ('2016-11-30'),

  ('2016-10-31'),

  ('2016-09-30'),

  ('2016-08-31'),

  ('2016-07-31'),

  ('2016-06-30'),

  ('2016-05-31'),

  ('2016-04-30'),

  ('2016-03-31'),

  ('2016-02-29'),

  ('2016-01-31'),

  ('2015-12-31'),

  ('2015-11-30'),

  ('2015-10-31'),

  ('2015-09-30'),

  ('2015-08-31'),

  ('2015-07-31'),

  ('2015-06-30'),

  ('2015-05-31'),

  ('2015-04-30'),

  ('2015-03-31'),

  ('2015-02-28'),

  ('2015-01-31')

  Expected result:

  Jul 2016

  Aug 2016

  Sep 2016

  Oct 2016

  Nov 2016

  Dec 2016

  Thank you.

  --chalam

• Stuart Davies

  SSCoach

  Points: 19271

  More actions

  December 22, 2016 at 12:45 am

  #1919266

  Hi - what have you tried so far?

  -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
  There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
  I would never join a club that would allow me as a member - Groucho Marx