December 21, 2016 at 10:43 pm
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
December 22, 2016 at 12:45 am
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply