Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# Get current Quarter and Fiscal Year ?

Posted on 2013-06-08
Medium Priority
1,209 Views
I found the code below at this site (http://stackoverflow.com/questions/11981453/get-current-quarter-in-year-with-javascript)

I'm trying to figure out how the code figures out the current quarter base on the Govt. fiscal year.
// For the US Government fiscal year
// Oct-Dec = 1
// Jan-Mar = 2
// Apr-Jun = 3
// Jul-Sep = 4

function getQuarter(d) {
d = d || new Date();
var m = Math.floor(d.getMonth()/3) + 2;
return m > 4? m - 5 : m;
}

Also, how would I get the current fiscal year?
0
Question by:Isaac
• 4
• 2

LVL 44

Accepted Solution

Rainer Jeschor earned 2000 total points
ID: 39231871
Hi
should be
var fiscalYear;
if (d.getMonth() > 8)
{ fiscalYear = d.getFullYear() + 1;} else { fiscalYear = d.getFullYear();}

HTH
Rainer
0

LVL 5

Author Comment

ID: 39231880
Hi Rainer,

could you please explain what you are checking for?
>>if(d.getMonth()>8)<<

Shouldn't it be 9 instead of 8?
0

LVL 44

Expert Comment

ID: 39231905
Hi,
no because Javascript date object starts the month enumeration with 0
0=January
...
8=September
http://www.w3schools.com/jsref/jsref_getmonth.asp
Therefore I check if it is October to December because then its the next fiscal year (year+1).

HTH
Rainer
0

LVL 44

Expert Comment

ID: 39231912
And your above formula should be incorrect as it would return 0 for months October to December:
9/3 = 3
3+2=5
5-5=0

So it should be
Â  return m > 4? m - 4 : m;

I am on the road therefore no coding environment to double check.
0

LVL 44

Expert Comment

ID: 39232175
Hi,
here the "proof": http://jsfiddle.net/EE_RainerJ/ALeMU/

HTH
Rainer
0

LVL 5

Author Closing Comment

ID: 39232220
Thanks!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Chart.js, used properly, can visually add a difference to your charting applications.Â It engages your visitors and allows them to interact with data they otherwise wouldn't be able to without expensive and complicated systems. For thisâ€¦
Introduction JSON is an acronym for JavaScript Object Notation.Â  It is a text-string data transport mechanism, capable of representing simple or complex data structures in a consistent and easy-to-read manner.Â  Similar in concept to XML, but more eâ€¦
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
###### Suggested Courses
Course of the Month11 days, 10 hours left to enroll