Findin the end date of the given date

[SSG001]

I have date in the format 200901(YYYYMM FORMAT)
now I want to find the end date in the format(yyyy-mm-dd)

[Markus]

Care to explain a little more? I don't see a question.

[TheServant]

WHere do you get the original format from? If your starting format is simply numbers I think the string will need to be split (explode() or something) into it's year and month and then you will have to re-declare it as a date so you can use PHP's built-in date format function.

[dlite922]

I'm no mind reader either but I could tell he's got only a month in the first format and by "end date" s/he means the last day of the given month.

Here's the code:

 
$firstDate = "200905"; // example may is 31 days, should return 2009-05-31
 
// Get the month and year
$year = substr($firstDate,0,4); 
$month = substr($firstDate,5,2); 
 
// get a TimeStamp of the first day
$firstDateTS = mktime(0,0,0,$month,1,$year); 
 
// get the last day of that month. 
$day = date("t",$date);
 
// convert it to a timeStamp again 
$endDateTS = mktime(0,0,0,$month,$day,$year); 
$endDate = date("Y-m-d",$endDateTS); 
 
// OR just print it
$endDate = "$year-$month-$day"; 
 
 
echo $endDate; 
 
 

Hope that helps,




Dan

[dlite922]

@Markus
Technically, you're right; however the OP did declare what s/he wanted...in as grammatically correct way as s/he could.

[numberwhun]

@dlite922
While I agree that there was no real question and also agree with your solution dlite, I also see where the OP could be asking how to figure out what the day referred to is, which would be a bit impossible without being told what the day is.

Regards,

Jeff