Forums

Full Version: How to get current quarter start and end date from dashboard
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
We will get date in yyyy-mm-dd format
Quarter indexing starts from zero

function current_quarter_start_date(quarter,year){
var aa=year+"-01-01";
 var bb=year+"-04-01";
 var cc=year+"-07-01";
 var dd=year+"-10-01";
if (quarter==1){return aa;}
else if (quarter==2){return bb;}
else if (quarter==3){return cc;}
else {return dd;}}

function current_quarter_end_date(quarter,year){
var aa=year+"-03-31";
 var bb=year+"-06-30";
 var cc=year+"-09-30";
 var dd=year+"-12-31";
if (quarter==1){return aa;}
else if (quarter==2){return bb;}
else if (quarter==3){return cc;}
else {return dd;}}

var date = new Date();
var year= date.getFullYear();
var current_quarter = Math.ceil((date.getMonth()+1) / 3);

var curqtr_start = current_quarter_start_date(current_quarter,year) );
var curqtr_end = current_quarter_end_date(current_quarter,year) );