calculate inbetween dates

dodgyone · May 20, 2002

I want to be able to display the dates inbetween and including the from and to dates given.

[So]...

From: 13/04/2002 To: 17/04/2002...

[This will result in]...

13/04/2002
14/04/2002
15/04/2002
16/04/2002
17/04/2002

I then need each date to be piped into an array so that it can be used later...

Any ideas or suggestions appreciated.

sleipnir214 · May 20, 2002

Do you have the Calendar functions enabled (i.e. was PHP compiled with the --enable-calendar)?

If so, you can convert both dates to Julian Day counts using the function gregoriantojd(), then use the resulting numbers as the bounds of a counter in a loop;

<?php
print "<html><body>";

$start = "13/04/2002";
$end = "17/4/2002";

$start_array = split ("/", $start);
$end_array = split ("/", $end);

$julian_start = gregoriantojd ($start_array[1], $start_array[0], $start_array[2]);
$julian_end = gregoriantojd ($end_array[1], $end_array[0], $end_array[2]);

for ($count = $julian_start; $count <= $julian_end; $count++)
{
print jdtogregorian($count)." ";
}

print "</body></html>";
?>

dodgyone · May 20, 2002

Unfortunately we do not have all of the calendar functions enable don the server. I don't have access to the server to be able to change these settings.

Do you have any more suggestions?

Thanks...

dodgyone · May 21, 2002

I'm now working around using the folowing idea:

#count the number of days involved between the dates
$numberdays = $dateto - $datefrom;

#create an array with all of the dates inbetween from and to
for ($i=0; $i<=$numberdays; $i++)
{

#calculates the date in the recurrence
echo date("Y-m-d", mktime(0,0,0,$monthfrom,$dayfrom+$i-date("w",mktime(0,0,0,$monthfrom,$dayfrom,$yearfrom)),$yearfrom));
echo " ";
}

I'm heading in the right direction but I cannot quite get it to work correctly...

KarveR · May 21, 2002

this might help you:

<?php

$month = date("m&quot

;
$day = date("d&quot

;
$year = date("Y&quot

;

echo "Today is $day $month $year<hr>";
echo "This week: ";
echo "Monday: ".date("d m Y", mktime(0,0,0,$month,$day+1-date("w",mktime(0,0,0,$month,$day,$year)),$year))." ";
echo "Friday: ".date("d m Y", mktime(0,0,0,$month,$day+5-date("w",mktime(0,0,0,$month,$day,$year)),$year))." ";
echo "<hr>";

echo "Next week: ";
echo "Monday is : ".date("d m Y", mktime(0,0,0,$month,$day+8-date("w",mktime(0,0,0,$month,$day,$year)),$year))." ";
echo "Friday is : ".date("d m Y", mktime(0,0,0,$month,$day+12-date("w",mktime(0,0,0,$month,$day,$year)),$year))." ";

?> ***************************************
Party on, dudes!
[cannon]

AnakinPt · May 21, 2002

a simple solution

for($i=0;($time=mktime(0,0,0,$begin_mon,$begin_day+$i,$begin_year))<=mktime(0,0,0,$end_mon,$end_day,$end_year);$i++){
echo date("d-m-Y",$time)." ";
}
Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com

KarveR · May 21, 2002

Anikin I follow your example and post hints and code that points in the right direction and you go and post a complete spoiler

***************************************
Party on, dudes!
[cannon]

AnakinPt · May 21, 2002

the complete code would be:

list($begin_day,$begin_mon,$begin_year)=explode("-",$begin);
list($end_day,$end_mon,$end_year)=explode("-",$end);

for($i=0;($time=mktime(0,0,0,$begin_mon,$begin_day+$i,$begin_year))<=mktime(0,0,0,$end_mon,$end_day,$end_year);$i++){
echo date("d-m-Y",$time)." ";
}

Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com

dodgyone · May 21, 2002

Thanks Karver... I got it from your examples.

I prefer your way of doing things... I prefer to learn from my mistakes ;o)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

calculate inbetween dates

dodgyone

Technical User

sleipnir214

Programmer

dodgyone

Technical User

dodgyone

Technical User

KarveR

MIS

AnakinPt

Programmer

KarveR

MIS

AnakinPt

Programmer

dodgyone

Technical User

Similar threads

Part and Inventory Search

Sponsor