Count the days since .... DateDiff

[CherryAA]

With advance apologies - I'm a newbie! This is probably very easy ..... I want this Excel formula:

DaysNumber=DATEDIF("03-Sept-2003",NOW(),"d")

It gives me the number of days that have elapsed since the 3rd September. I've tried all permutations of DATEDIFF that I can think of, but I'm doing something horribly wrong! :confused:

PLEASE can somebody help????!!!!

Thanks
Cherry

[gizmo]

This is an HTML forum, you're not likely to get an answer here.:eek:

[CherryAA]

.... now I feel even more stupid!

Er, what language should I be looking at to put a calculated field into an HTML page?

[Cringing with embarrassement]

C

[gizmo]

A mistake is a sign that someone has tried to do something. Keep trying, I think a PHP script could do what you are after. I am a PHP newbie, but will have a go myself, give me a few hours. :D
gizmo

[gizmo]

CherryAA, have a look at http://www.php.net/manual/en/ref.datetime.php while you are waiting...:D

[CherryAA]

Originally posted by gizmo
A mistake is a sign that someone has tried to do something. Keep trying,:D

That's a really nice thing to say! Thanks :)

Am checking your link now ......

Cx

[pyro]

You can try something like this:

<?PHP
$today = time();
$date = "09-03-2003";
list ($month, $day, $year) = preg_split("/[\\/-]/", $date);
$date= mktime (0,0,0,$month,$day,$year);
$diff = floor(($today - $date)/60/60/24);
echo "$diff days different";
?>

[CherryAA]

Grrr, how annoying. That looks like it should work, but it just disappeared on my page. Maybe I need to wrap it up more ... I'll try again later!

Thank you both for your help & tolerance!

C :)

[pyro]

Does your server support PHP?

[PeOfEo]

I can whip something up in asp.net if your server happens to support that :) But asp.net hosting is not as common and you would probably know if your host supported it :rolleyes:

[CherryAA]

... for all the replies!

I still don't know why Pyro's script didn't work, but I eventually found a javascript in the javascript Source :rolleyes: that was easily modified to return days. It's still counting.

Cheers :)

[wmbs]

I use a JS script by Alan Palmer to count days since a date in the past and days until a date in the future. You can see the code in action at http://hammerlogic.com

[PeOfEo]

The poem about this forum I am making up on the fly
and then another thread
came back from the dead