recording 'sick days'

Results 1 to 3 of 3

Thread: recording 'sick days'

  1. #1
    J Guest

    Default recording 'sick days'

    I need to record absences into a database, I have all off the pages working, (to insert data, choose sick type, etc), but I have a problem.<BR>I enter the start and end dates, but I only want to count the days monday to saturday as sick days.<BR>Does anybody know how I can do this.<BR>I was thinking about just minusing 1 day from every 7, but that wil be wrong, if somebody is off from thursday to tuesday, the sunday is not included then.<BR>I waffling...<BR><BR>can anybody help ?<BR><BR>thank you .<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: recording 'sick days'

    Look up the weekday function in the VBScript reference that is located in the left margin of this page.<BR><BR><BR><BR><BR><BR>mj

  3. #3
    J Guest

    Default RE: recording 'sick days'

    Dim Myweekday, startdate, enddate<BR>StartDate = &#060;%StartDate%&#062;<BR>EndDate = &#060;%EndDate%&#062;<BR>MyWeekDay = Weekday(MyDate) <BR><BR>So I would use something like this, but how do I say if myweekday = sunday then dont add up the numbers ?<BR><BR>sorry as you can see my script and as pis pretty weak !<BR>

Posting Permissions

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