Getting All Dates for Mondays and Tuesdays for the Next Year

Getting all dates for Mondays and Tuesdays for the next year

This is an interesting one. Here's how I'd do it with functions, though it may warrant its own class to really be modular and reusable:

Set up my date formats and excluded dates
define('INTERNAL_FORMAT', 'Y-m-d');
define('DISPLAY_MONTH_FORMAT', 'M Y');
define('DISPLAY_DAY_FORMAT', 'D d M Y');
// format excluded dates as YYYY-MM-DD, date('Y-m-d'):
$excluded_dates = array(
'2010-03-09',
'2010-04-13',
);

Then I need some utility functions to see how the dates run, and what dates are excluded:

// date('w') returns a string numeral as follows:
// '0' Sunday
// '1' Monday
// '2' Tuesday
// '3' Wednesday
// '4' Thursday
// '5' Friday
// '6' Saturday
function isTuesday($date) {
return date('w', strtotime($date)) === '2';
}
function isWednesday($date) {
return date('w', strtotime($date)) === '3';
}

// handle the excluded dates
function isExcludedDate($internal_date) {
global $excluded_dates;
return in_array($internal_date, $excluded_dates);
}

Now we just need to iterate over every day of the next 365 (the next year) and check to see if they're Tuesday or Wednesday and not on the excluded list. We store this in $months_and_dates:

$start_date = date(INTERNAL_FORMAT);

// something to store months and days
$months_and_dates = array();

// loop over 365 days and look for tuesdays or wednesdays not in the excluded list
foreach(range(0,365) as $day) {
$internal_date = date(INTERNAL_FORMAT, strtotime("{$start_date} + {$day} days"));
$this_day = date(DISPLAY_DAY_FORMAT, strtotime($internal_date));
$this_month = date(DISPLAY_MONTH_FORMAT, strtotime($internal_date));
if ((isTuesday($internal_date) || isWednesday($internal_date))
&& !isExcludedDate($internal_date)) {
$months_and_dates[$this_month][] = $this_day;
}
}

You can print_r() it, or to get the display you want, we do this:

foreach($months_and_dates as $month => $days) {
print $month . "<br>";
print implode('<br>', $days);
print "<br>";
}

Here's the result as of today, January 11, 2010:

Jan 2010
Tue 12 Jan 2010
Wed 13 Jan 2010
Tue 19 Jan 2010
Wed 20 Jan 2010
Tue 26 Jan 2010
Wed 27 Jan 2010
Feb 2010
Tue 02 Feb 2010
Wed 03 Feb 2010
Tue 09 Feb 2010
Wed 10 Feb 2010
Tue 16 Feb 2010
Wed 17 Feb 2010
Tue 23 Feb 2010
Wed 24 Feb 2010
Mar 2010
Tue 02 Mar 2010
Wed 03 Mar 2010
Wed 10 Mar 2010
Tue 16 Mar 2010
Wed 17 Mar 2010
Tue 23 Mar 2010
Wed 24 Mar 2010
Tue 30 Mar 2010
Wed 31 Mar 2010
Apr 2010
Tue 06 Apr 2010
Wed 07 Apr 2010
Wed 14 Apr 2010
Tue 20 Apr 2010
Wed 21 Apr 2010
Tue 27 Apr 2010
Wed 28 Apr 2010
May 2010
Tue 04 May 2010
Wed 05 May 2010
Tue 11 May 2010
Wed 12 May 2010
Tue 18 May 2010
Wed 19 May 2010
Tue 25 May 2010
Wed 26 May 2010
Jun 2010
Tue 01 Jun 2010
Wed 02 Jun 2010
Tue 08 Jun 2010
Wed 09 Jun 2010
Tue 15 Jun 2010
Wed 16 Jun 2010
Tue 22 Jun 2010
Wed 23 Jun 2010
Tue 29 Jun 2010
Wed 30 Jun 2010
Jul 2010
Tue 06 Jul 2010
Wed 07 Jul 2010
Tue 13 Jul 2010
Wed 14 Jul 2010
Tue 20 Jul 2010
Wed 21 Jul 2010
Tue 27 Jul 2010
Wed 28 Jul 2010
Aug 2010
Tue 03 Aug 2010
Wed 04 Aug 2010
Tue 10 Aug 2010
Wed 11 Aug 2010
Tue 17 Aug 2010
Wed 18 Aug 2010
Tue 24 Aug 2010
Wed 25 Aug 2010
Tue 31 Aug 2010
Sep 2010
Wed 01 Sep 2010
Tue 07 Sep 2010
Wed 08 Sep 2010
Tue 14 Sep 2010
Wed 15 Sep 2010
Tue 21 Sep 2010
Wed 22 Sep 2010
Tue 28 Sep 2010
Wed 29 Sep 2010
Oct 2010
Tue 05 Oct 2010
Wed 06 Oct 2010
Tue 12 Oct 2010
Wed 13 Oct 2010
Tue 19 Oct 2010
Wed 20 Oct 2010
Tue 26 Oct 2010
Wed 27 Oct 2010
Nov 2010
Tue 02 Nov 2010
Wed 03 Nov 2010
Tue 09 Nov 2010
Wed 10 Nov 2010
Tue 16 Nov 2010
Wed 17 Nov 2010
Tue 23 Nov 2010
Wed 24 Nov 2010
Tue 30 Nov 2010
Dec 2010
Wed 01 Dec 2010
Tue 07 Dec 2010
Wed 08 Dec 2010
Tue 14 Dec 2010
Wed 15 Dec 2010
Tue 21 Dec 2010
Wed 22 Dec 2010
Tue 28 Dec 2010
Wed 29 Dec 2010
Jan 2011
Tue 04 Jan 2011
Wed 05 Jan 2011
Tue 11 Jan 2011

How to get the dates for all mondays between two dates but only for whole weeks within the range with PHP?

One possible approach:

function isMonday($date) {
return $date->format('N') === '1';
}

function isSunday($date) {
return $date->format('N') === '7';
}

function getMondays($start, $end) {
$mondays = [];

$datePeriod = new DatePeriod($start, new DateInterval('P1D'), $end);
foreach ($datePeriod as $date) {
if (isMonday($date)) $mondays[] = $date;
}
if (!isSunday($end)) array_pop($mondays);
return $mondays;
}

$startDate = new DateTime('2021-06-20');
$endDate = new DateTime('2021-07-07');
var_dump(getMondays($startDate, $endDate));

3v4l Demo. It's rather direct: there's a DatePeriod Traversable object created from $start and $end dates with 1 day interval, that is iterated with foreach; each date that's a Monday is stored in an array. Last step is discarding the very last item of that array if the endDate is not Sunday.

How to get all sundays/mondays/tuesdays between two dates?

Use a loop to continually get the date for next Sunday until you pass the ending date.

var start = moment('2016-09-01'), // Sept. 1st    end   = moment('2016-11-02'), // Nov. 2nd    day   = 0;                    // Sunday
var result = [];var current = start.clone();
while (current.day(7 + day).isBefore(end)) { result.push(current.clone());}
console.log(result.map(m => m.format('LLLL')));
<script src="//cdnjs.cloudflare.com/ajax/libs/moment.js/2.17.1/moment.min.js"></script>

PHP - Get all the dates that falls on a given Day of the week in a year

The interval is always 7 days, so just work out the start date as a DateTime object for the first "monday" of the year, end date as a year from then, and use DatePeriod to loop through that date range with an interval of every 7 days

$startDate = new DateTime('2016-01-01');
$startDate->modify('first monday');
$endDate = clone $startDate;
$endDate = $endDate->add(new DateInterval('P1Y'));

$interval = new DateInterval('P7D');

$period = new DatePeriod($startDate, $interval, $endDate);
foreach ($period as $date) {
echo $date->format('Y-m-d').PHP_EOL;
}

Adjust start and end dates to taste

How could I get the the Nth Monday, Tuesday, etc. of every month between two dates using JavaScript

To get the nth instance of a day in the month, create a date for the first of the month, move to the first instance of the required day, then add (n-1) weeks worth of days, e.g.

/* Get nth instance of a particular weekday in a month
*
* @param {number|string} nth - instance of day, 1 to 4
* @param {number|string} day - day of week, Sun 0, Mon 1, etc.
* @param {Date} month - any date in month to get day of
* @returns {Date} that is nth instance of day in month
*/
function getNthDayInMonth(nth, day, month) {
// Create new date for 1st of month
let d = new Date(month.getFullYear(), month.getMonth());
// Move to first instance of day in month and
// add (n - 1) weeks
d.setDate(1 + (7 - d.getDay() + day)%7 + (nth - 1)*7);
return d;
}

// Formater
let f = (d) => new Intl.DateTimeFormat('en-GB', {
weekday:'short',
day:'2-digit',
month:'short',
year: 'numeric'
}).format(d);

// Examples
[[1,1,new Date(2021,11),'1st Mon in Dec 2021'],
[3,3,new Date(2022, 0),'3rd Wed in Jan 2022'],
[4,1,new Date(2022, 1),'4th Mon in Feb 2022'],
[4,2,new Date(2022, 1),'4th Tue in Feb 2022'],
[4,3,new Date(2022, 1),'4th Wed in Feb 2022'],
[1,3,new Date(2022, 5),'1st Wed in Jun 2022'],
[5,5,new Date(2022,11),'5th Fri in Dec 2022']
].forEach(a => {
let [n,d,m,note] = a;
console.log(`${note}: ${f(getNthDayInMonth(n,d,m))}`);
});

How can I select all of the Sundays for a year using Python?

You can use date from the datetime module to find the first Sunday in a year and then keep adding seven days, generating new Sundays:

from datetime import date, timedelta

def allsundays(year):
d = date(year, 1, 1) # January 1st
d += timedelta(days = 6 - d.weekday()) # First Sunday
while d.year == year:
yield d
d += timedelta(days = 7)

for d in allsundays(2010):
print(d)

Get Monday's date every week in between two dates

DateTime date = LimitVmodel.StartDate;

switch (LimitVmodel) {
case "Monday":
while (date.DayOfWeek != DayOfWeek.Monday) {
date = date.AddDays(1);
}
break;
case "Tuesday":
while (date.DayOfWeek != DayOfWeek.Tuesday) {
date = date.AddDays(1);
}
break;
//Etc...
}
AllDates.add(date);
while (DateTime.compare(date, LimitVmodel.EndDate) <= 0) {
date = date.AddDays(7);
AllDates.add(date);
}

Need to get the dates of all mondays in a year

To get all mondays, by getting all dates and filtering by Mondays:

for i in `seq 0 365`
do date -d "+$i day"
done | grep Mon

Of course, you could also take a monday and keep incrementing by 7 days.



Related Topics



Leave a reply



Submit