[Resolved] pull partial variable info

dreams4000

Hi all,

I have a variable, say $date.. it is = to a date like 2004-08-22.. I am trying to do a statement that says if the month in $date is = to 08, then do the command I need... The variable has to be the full year-month-date.. so the question is, is there any way to compare to just the month portion of the date variable instead of the whole thing?

thanks!

TheDefender

$date = "2004-08-22";
IF(date("m", strtotime($date)) == "08"){
// Do this
} else {
// Do this if it isn't
}

You should find the date() and strtotime() to be handy for your needs.

dreams4000

Hey there,

Thanks for the code! It works and spits out the correct data, but it also spits out this error:

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in.... (the file and line of the code you just gave)

The dates I am working with are not prior to 1970 either. Any way to deal with that one? Thanks!

TheDefender

How is the date spit out? Are you inputting any calues without the leading 0s? Like 2004-7-22 instead of 2004-07-22?

Post some code, and we'll look at it...

dreams4000

Ok, I tried the exact code you gave, and that did not work datawise, but did stop the errors. It doesn't process the "else" statement and just runs the first statement for everything. What was working data wise but with the error was this,


if (date("m", strtotime($listTeam->sdesk_date[$i])) == '08') {

$block10->cellRow($projectDetail->pro_aug[0]);

} else {
	echo "Incorrect";

}

I am not sure why the $date = "2004-08-17"; specfication did not process right, but the $listTeam one I have up there does. The $listTeam specification merely is the same thing as $date but is being pulled from a mysql database that has 2004-08-17 stored in one of its columns. It is stored just as you see it with no changes. Any ideas?

TheDefender

Can you post some of the class/function info you are using to generate the data? Also, the $date = "2004-08/22"; method should parse properly. It is one of the formats accepted by the strtotime() function...

dreams4000

ok, $listteam is running a mysql query to call specific data, sdesk_date is a specific column from that mysql call, and the $i is just to list a variable number of rows.. so the output is just a listing of items that match my criteria. Nothing changes the date at all, though I have heard that using the date() function whith mysql called items can create this 1970 issue, but not sure what statement needs to be placed to correct it.

dreams4000

could it be that it is looking at the day part of the date instead of the year? It seems from the php site that the normal format is d-m-y instead of y-m-d so maybe it is reading my day as my year and seeing it as too small? Just a thought.. im fairly new at messing with dates and such.

dreams4000

I think I got that one figured out. Sorry for the confusion. I found an entry that didnt have an all number date that was nukin it. It all works. thanks for your help!! I appreciate it.

TheDefender

No problem... Glad it all worked out.