I want to get all the start and the end dates of weeks of a year starting 2022 in moment in YYYY-MM-DD (mysql) format.
I want the end result to look something like this:
[
['2022-01-04', '2022-01-10'],
['2022-01-11', '2022-01-17'],
['2022-01-18', '2022-01-24'],
// ...
['2022-12-24', '2023-01-01'],
['2023-01-02', '2023-01-08'],
// ...
['2023-12-25', '2024-01-01'],
// ...
// Until the end of 2026
];
EDIT 1: I tried the code below but it's failing:
const moment = require('moment');
const dateFormat = 'YYYY-MM-DD';
const dateToStart = '2022-04-11';
const dateToEnd = '2030-12-29';
function getWeeks() {
const weeks = [];
let currentDate = '2022-04-11';
while (true) {
if (currentDate === dateToStart) {
weeks.push([dateToStart, moment(dateToStart, dateFormat).add(6, 'days').format(dateFormat)]);
} else {
weeks.push([
moment(currentDate, dateFormat).add(1, 'days').format(dateFormat),
moment(currentDate, dateFormat).add(6, 'days').format(dateFormat),
]);
}
currentDate = moment(dateToStart).add(6, 'days').format(dateFormat);
if (currentDate === dateToEnd) break;
}
return weeks;
}
Momentjs provide some really usefull functions to get the desired output.
isAfter
start.startOf('isoWeek')
and .endOf('isoWeek')
to get the range of a week.add(1, 'week')
This example should get you started, note that I've lowered the dateToEnd
.
const dateFormat = 'YYYY-MM-DD';
const dateToStart = '2022-04-01';
const dateToEnd = '2023-12-29';
let weeks = [];
let momsrt = moment.utc(dateToStart, dateFormat);
let momend = moment.utc(dateToEnd, dateFormat);
while (momend.isAfter(momsrt)) {
weeks.push([
momsrt.startOf('isoWeek').format(dateFormat),
momsrt.endOf('isoWeek').format(dateFormat)
]);
momsrt.add(1, 'week');
}
console.log(weeks);
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.1/moment.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment-timezone/0.5.32/moment-timezone-with-data.min.js"></script>
Foot Note:
Please see momentjs Project status
TL:DR; Don't use it for new projects, there are way better alternatives.