Need help to untangle logic

[zzz]

I need to display output for two months.

• Current month
• Previous month

My current month does not start on the 1st of the month but rather delayed 2 or 3 weeks, which I do like this:

// gets current month 
	$currMonth = date('n',time());
	$prevWeek = strtotime("-2 week");

// gets Month of previous week 
	$monthPrevWeek = date('n',$prevWeek);
	$checkMonth = $currMonth;

// if this month is greater than last week's month number (i.e. last week was a different month), use last week's month to check events 

if ($currMonth == 1) { //if January
	$checkMonth = 12;
} else {
	if ($currMonth > $monthPrevWeek) {
		$checkMonth = $monthPrevWeek; 
	}
}

$current_month = date('F', strtotime($checkMonth . '/1'));

////// Logic to get stats based on the time of month <<--

//// Year logic -->>

$yearNow = date("Y");

if ($checkMonth == '1') {
	$YearPastMonth = ($yearNow - 1);
} else {
	$YearPastMonth = $yearNow;
}

//// Year logic <<--

So I need to write two quesries, for "current" and "previous" months. I do it like this:

// CURRENT MONTH
SELECT...
WHERE...
AND MONTH(issue_date) = ".$checkMonth."
AND YEAR(issue_date) = ".$YearPastMonth."

// PREVIOUS MONTH
SELECT...
WHERE...
AND MONTH(issue_date) = ".$prev_month_number."
AND YEAR(issue_date) = ".$YearPastMonth."

I guess I started over complicating when the year came to change. Say today is January 13 2007, so my "current month" should be December 2006 (-2 weeks), and my "previous month" should be November 2006.

But if today is January 15: "current month" should be January 2007, and "previous month" December 2006.

I'm deep in the woods at this point and desperately need help. I must keep the same var names as it's on the live site.

[Piranha]

Sorry for being a pain in the ass, but what is the problem? I understand that it does not show the right month some times, but when does it not show the right month? Is it showing the right month the 13th? The 15th?

[zzz]

It's all confused. It shows the right month but wrong year etc.

I've attempted to detangle it. Please take a look and see if there are any red flags.

////// Logic to get stats based on the time of month -->>
// IMPORTANT!!! It'll use previous month is less then a week of current month elapsed.
// gets current month 
	$currMonth = date('n',time());
	$prevWeek = strtotime("-2 week");

$yearNow = date("Y");

// gets Month of previous week 
	$monthPrevWeek = date('n',$prevWeek);
//	$checkMonth = $currMonth;

// if this month is greater than last week's month number (i.e. last week was a different month), use last week's month to check events 

if ($currMonth == 1 && $monthPrevWeek = 12) { //if January
	$checkMonth = 12;
	$checkYear = ($yearNow - 1);
} else {
	$checkMonth = $monthPrevWeek;
	$checkYear = $yearNow;
}

if ($checkMonth == 1) {
	$prev_month_number = 12;
	$YearPastMonth = $checkYear - 1;
} else {
	$prev_month_number = $currMonth - 1;
	$YearPastMonth = $checkYear;
} 

// QUERIES:

// CURRENT MONTH 
SELECT... 
WHERE... 
AND MONTH(issue_date) = ".$checkMonth."
AND YEAR(issue_date) = ".$checkYear." 

// PREVIOUS MONTH 
SELECT... 
WHERE... 
AND MONTH(issue_date) = ".$prev_month_number." 
AND YEAR(issue_date) = ".$YearPastMonth."

It appers to work right now but I am a bit concerned what may happen in a couple of weeks. or next January.

[Weedpacket]

zzz wrote:

delayed 2 or 3 weeks

which is it? How is that decided?

which I do like this

Which doesn't work, so it leaves us in the dark.

I'm going to take a guess here. The current "working" month is the one in which the current day occurs. The start of the working month is two weeks after the start of the calendar month (I have no idea how the "or 3" works); so 4th January actually belongs to "working December", because "working January" hasn't started yet.

// Sneakily pretend the system clock is two weeks out of synch
list($y,$m) = explode(':', date('Y:m', strtotime('-2 weeks'));
$current_month_starts = mktime(0,0,0,$m,1,$y);
$previous_month_starts=strtotime('-1 month', $current_month_starts);
// Shift forward two weeks again
$current_month_starts = strtotime('+2 weeks', $current_month_starts);
$previous_month_starts = strtotime('+2 weeks', $previous_month_starts);

And then you'd use date() to reformat those timestamps.