Solved

Get current Quarter and Fiscal Year ?

Posted on 2013-06-08
6
1,070 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 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

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

by:Rainer Jeschor
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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 44

Expert Comment

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

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

HTH
Rainer
0
 
LVL 5

Author Closing Comment

by:Isaac
ID: 39232220
Thanks!
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

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.
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
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…

726 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