Difference between two dates

[Anon]

Hi!

I'm asking the user to enter a date in mm/dd/yy format and storing it in the access database. I want to know how I can find number of days between the current date and that date entered.

Regards,

Mahesh

[thepriest]

convert the dates to timestamps.

then subtracting the two dates will give you the number of seconds between them.

so divide by 86400 to get the number of days

hope this helps,
stef

[sujithnair]

Hi,
Just convert it into a timestamp using mktime() function. This would give u the total number of seconds. Now use these seconds to calculate the difference. But care should be taken while dealing with timestamps, because it will only work for dates after epoch i.e 1970.
Bye..