+- Forums (https://bdn.bdb.ai)
+-- Forum: BDB Knowledge Base (https://bdn.bdb.ai/forumdisplay.php?fid=13)
+--- Forum: BDB Dashboards Designer (https://bdn.bdb.ai/forumdisplay.php?fid=43)
+---- Forum: BDB Designer Q & A (https://bdn.bdb.ai/forumdisplay.php?fid=16)
+---- Thread: Script to get previous month start and end date (/showthread.php?tid=659)
Script to get previous month start and end date - abhishek_acharya - 12-26-2022
We will get date in yyyy-mm-dd format
Indexing starts from zero for month
var date = new Date();
var curr_month = date.getMonth();
var currentYear = date.getFullYear();
function padTo2Digits(num) {return num.toString().padStart(2, '0');}
function cur_month(date) {
return [
date.getFullYear(),
padTo2Digits(date.getMonth() + 1),
padTo2Digits(date.getDate()),
].join('-');
}
if (curr_month==0)
{var pre_month1 = 11;
var currentYear1 = currentYear-1;}
else {var pre_month1 =curr_month-1 ;
var currentYear1 = currentYear;}
var premonth_start = cur_month(new Date(currentYear1, pre_month1, 1)) );
var premonth_end = cur_month(new Date(currentYear1, pre_month1 + 1, 0)) );