Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Oct 2006
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Unsure how to handle advanced date calculations

    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.

  • #2
    Banned
    Join Date
    Oct 2005
    Location
    I'm in GMT -5
    Posts
    314
    Thanks
    0
    Thanked 1 Time in 1 Post
    Shaun:

    Post the complete form.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •