473,287 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Calculate Weekdays in ASP

Hi All

I need to calculate the number of working days between the two dates entered
on an ASP page. I am not that great a coder in ASP and was wondering if
someone can help.

Basically the form has Two textboxes to enter dates

From Date - Fdate
To Date - TDate
Number of days - NoDays (This field needs to be populated by the function
once the function/sub has been executed)

The function should be able to calculate number of working days between the
two dates but MUST exclude the list of public holidays between the two days.
The list of public holidys for each year is stored in a database table.

The form I am using also has two check boxes called

Include Saturdays
Include Sundays

If any of the two checkboxes are checked it must include the relevant days
in the calculation if not then sat/sun must be excluded from the
calculation.

Thanks in advance for your help it is highly appreciated
Jul 19 '05 #1
2 4698
JP SIngh wrote on 13 jul 2004 in
microsoft.public.inetserver.asp.general:
I need to calculate the number of working days between the two dates
entered on an ASP page. I am not that great a coder in ASP and was
wondering if someone can help.


Google is your friend, even serverside.

http://groups.google.com/groups?q=wo...+group%3A*.asp

http://groups.google.com/groups?q=ca...+group%3A*.asp

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Jul 19 '05 #2
Since VBScript has absolutely no concept of your company's holidays, you
might be better off using a calendar table.

http://www.aspfaq.com/2453
http://www.aspfaq.com/2519

--
http://www.aspfaq.com/
(Reverse address to reply.)


"JP SIngh" <no**@none.com> wrote in message
news:u$**************@tk2msftngp13.phx.gbl...
Hi All

I need to calculate the number of working days between the two dates entered on an ASP page. I am not that great a coder in ASP and was wondering if
someone can help.

Basically the form has Two textboxes to enter dates

From Date - Fdate
To Date - TDate
Number of days - NoDays (This field needs to be populated by the function
once the function/sub has been executed)

The function should be able to calculate number of working days between the two dates but MUST exclude the list of public holidays between the two days. The list of public holidys for each year is stored in a database table.

The form I am using also has two check boxes called

Include Saturdays
Include Sundays

If any of the two checkboxes are checked it must include the relevant days
in the calculation if not then sat/sun must be excluded from the
calculation.

Thanks in advance for your help it is highly appreciated

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tiernan | last post by:
Hi all I'm looking for a way to find the number of weekdays between 2 dates In my form I have three fields for a begin date (dd)(mm)(yyyy) and three for the end date (dd)(mm)(yyyy) Now these...
5
by: SimonC | last post by:
Help needed for a Javascript beginner. As above in the subject... i need a javascript to run this, but not in the form of a web-page. I want to calculate it between 2 fields in a database that...
1
by: Htk | last post by:
I have two date fields: -Inquiry Date -Action Date I'm trying to use a query expression on this. Using the datediff expression, I can get the amount of days that seperate the two dates. But I...
1
by: Chris Hill via .NET 247 | last post by:
Hi I'm a jnr developer in need of desparate help. Can anyone point me in the right direction for this problem: I calculate the number of days between 2 user defined dates like this: Dim...
0
NeoPa
by: NeoPa | last post by:
This code is quite old and may be bettered. If anyone feels they can produce better code for this function go ahead and PM me your effort. If I feel that it is better (More efficient & 100%...
8
by: atiq | last post by:
I am trying to restrict the user to only enter date which is weekdays. so, it shouldn't allow a date that is weekend such as 08/04/07 (Sunday). Can someone help me with this issue. In short i want...
4
by: MLH | last post by:
I'm thinking of an integer field in which I could write values up to 1+2+4+8+16+32+64 and to use these values later. Each of the individual values would represent a weekday from Sunday to Saturday....
2
by: Mike | last post by:
Is there a way to calculate the total number of weekdays when provided a date? Example: If I have a start date of 7/11/2008 and I want to go out 10 days, I want to get this: 6 weekdays 4...
1
by: bharathreddy | last post by:
This article will explain how we can get the count of weekdays in between two dates. This will be usefull if we want to count the number of working days between two dates. Example: -------------...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.