...

View Full Version : Unsure how to handle advanced date calculations



shaun09
10-17-2006, 03:01 PM
I need to come up with a leave application script. For example i have 21days of annual leave. The actual amount will be taken from a database. If i select today from the drop down box and one week later in the other drop down, the script will automaticall minus 7 days out of the 21 days. I'm able to find the script for this. The script as follows :

<script type="text/javascript">

function checkDate(nForm){

var sDate = nForm['dc1'].value;
sDate = sDate.split('-');
sDate = new Date(sDate[2],sDate[1]-1,sDate[0])
var eDate = nForm['dc2'].value;
eDate = eDate.split('-');
eDate = new Date(eDate[2],eDate[1]-1,eDate[0])
nForm['daysApart'].value = (eDate-sDate)/86400000;
nForm['hiddenElmName'].value=nForm['daysApart'].value
alert(nForm['daysApart'].value);

return true;
}

</script>

I'm not sure how to modify the script when half days are taken. For example if i take 2.5 days of leave the script must be able calculate that there is 19.5 days of leave left. There will be 2 radio buttons, One called "Full day" the other "Half Day"


dc1 : Textbox (Date selector script)
dc2 : Textbox (Date selector script)

Server side script jsp, Mysql

Thank you so very much for your help. I'm a total newbie. Greatly appreciated.

Ancora
10-18-2006, 01:41 PM
Shaun:

Post the complete form.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum