Solved

Get current Quarter and Fiscal Year ?

Posted on 2013-06-08
6
1,020 Views
Last Modified: 2013-06-08
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
Comment
Question by:Isaac
  • 4
  • 2
6 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
Comment Utility
Hi
should be
var fiscalYear;
if (d.getMonth() > 8)
{ fiscalYear = d.getFullYear() + 1;} else { fiscalYear = d.getFullYear();}

HTH
Rainer
0
 
LVL 5

Author Comment

by:Isaac
Comment Utility
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

by:Rainer Jeschor
Comment Utility
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 44

Expert Comment

by:Rainer Jeschor
Comment Utility
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

by:Rainer Jeschor
Comment Utility
Hi,
here the "proof": http://jsfiddle.net/EE_RainerJ/ALeMU/

HTH
Rainer
0
 
LVL 5

Author Closing Comment

by:Isaac
Comment Utility
Thanks!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In this article you'll learn how to use Ajax calls within your CodeIgniter application. To explain this, I'll illustrate how to implement a simple contact form to allow visitors to send you an email through your web site.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery including how to code hide show and toggles. 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…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now