|
 |
asp_web_howto thread: Calculating dates
Message #1 by "Dimitri Dhont" <ddhont@e...> on Tue, 29 Jan 2002 15:30:03
|
|
Hi,
Im currently working on a leavecard system on our intranet. This system also calculates the remaining
hours of leave left. The only problem I have is when a user's leave covers a public holiday, that day
shouldn't be substracted from his/her total. Anybody got a clue how to get this working? I already have
a table where all holidays are listed.
Thanks for any suggestions!
Regards,
Dimitri
Message #2 by "O'Hara, Elliott M" <EMOHARA@k...> on Tue, 29 Jan 2002 10:37:46 -0500
|
|
How about some code??
I can think of a few way...
depends on how youve already got it set up.
You submitting, then calculating??? Thats what I'd recommend. That way you
still know that they were on leave during a holiday, just not charged.....
If that is the case just add a WHERE NOT IN clause on your query when you
tally the dates leave was taken....
-----Original Message-----
From: Dimitri Dhont [mailto:ddhont@e...]
Sent: Tuesday, January 29, 2002 10:30 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Calculating dates
Hi,
Im currently working on a leavecard system on our intranet. This system also
calculates the remaining
hours of leave left. The only problem I have is when a user's leave covers a
public holiday, that day
shouldn't be substracted from his/her total. Anybody got a clue how to get
this working? I already have
a table where all holidays are listed.
Thanks for any suggestions!
Regards,
Dimitri
$subst('Email.Unsub').
|
|
|
