MySQL Forums
Forum List  »  Newbie

Auto Calculate Total DAYS for leave, help please!
Posted by: Raffiq Eddy
Date: April 15, 2005 12:52AM

Dear MySQL & PHP Expert...

I want to auto calculate DAYS for leave taken based on date key-in by user:

For example:

Start date: 15-04-2004 -- (Friday)
End date: 18-04-2004 -- (Monday)
Days: 3 -- (calculate automatically)

From the date given above, system will automatically:-
1) Count days as 3 -- assuming working day is 15, 16 and 18 only.
2) Sunday will not be count as working day.

Is this possible with MySQL(3.32) + PHP ??

TIA,

Regards.

Options: ReplyQuote


Subject
Written By
Posted
Auto Calculate Total DAYS for leave, help please!
April 15, 2005 12:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.