calculate dateout without weekend days in a form

107 New Member

Hello,
I have a form.
When a user enters item number Date shipped field is filled with current date.
TurnAroundTime is a number field to add the number of days to Date shipped.

DatOut is an unbound textbox on form.
I want DateOut filled with Date shipped + TurnAroundTime.
The turn around time number is static and assigned to Item numbers.

I have tried creating a module and a call in the main form and subforms.
I cannot get the DateOut to display -Date shipped + TurnAroundTime.
I have tried making a field for DateOut also.

The form has already been created and I am modifying it. It has a thousand or so records.The DateOut field already has data in it.
I thought I would make a unbound textbox to display date and just enter it in DateOut field.
any ideas or suggestions?
thank you

Aug 19 '08 #1

Subscribe Reply

1978

youmike

New Member

It looks as if you should be using the "After Update" event attached to the control that you call "TurnAroundTime ". If this is indeed so, don't forget to put the appropriate Requery, Refresh, Repaint after the calculation.

If you want to count weekdays only, you will probably have to include a Do/while loop to examine each day in the time period and count it if it is a weekday. This you would have to test using the Weekday function, counting the days only if the Weekday value is less than 6.

If you need to exclude public holidays as well, this would add another level of complication, which you would have to test by referring each date to a table of public holiday dates and excluding if there is a match.

A final thought - if you need to do this repeatedly, it might be worth writing code in a module, which could be used in a range of situations. In this case, you would need to pass parameters to and from the module using global constants.

Aug 19 '08 #2

buddyr

107

New Member

thank you,
unfortunately, I am hitting a block with the TurnAroundTime. I stumbled upon somthing like you said - using refresh- but then I had problems and still null values errors- main problem did not have handle on what I was doing.
can you be any more specific?
thank you

Aug 19 '08 #3

buddyr

107

New Member

am going to try to make a clearer question- thank you for your help here

Aug 20 '08 #4

Similar topics

4737

Calculate Weekdays in ASP

by: JP SIngh | last post by:

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

ASP / Active Server Pages

3472

Weekend date given a date

by: AdityaK | last post by:

Is there anyway I can get weekend date for a given date using DB2 query? I couldn't find any DB2 function that can be used to do so. Thanks, Aditya

DB2 Database

27967

Calculate Number of Years, Months and Days between 2 dates

by: carl.barrett | last post by:

Hi, I have a continuous form based on a query ( I will also be creating a report based on the same query). There are 2 fields: Date Obtained and Date Of Expiry I want a further 3 columns to the right of these 2 fields to show the

Microsoft Access / VBA

25984

How do I calculate business days

by: Sam | last post by:

Hi, I use C# in my ASP.NET projects. Here's what I need to do: I want to add x business days to a given date i.e. add 12 business days to today's date. What is the best, fastest and most efficient way for me to do this? -- Thanks, Sam

C# / C Sharp

5957

DateDiff to calculate Weeks and Days function

by: Libber39 | last post by:

Hi everyone, Have a query on how to calculate the amount of weeks and days contained in a number in an access query. ie: the difference in days between 2 dates amounts to 17 days. I want to now calculate in the query the amount of weeks and days within the 17 days to show 2 weeks 3 days. I can create the function within excel, (A1 as cell with the days within it) as: =INT(A1/7) & " Weeks, " & MOD(A1,7) & " days" but cant seem to...

Microsoft Access / VBA

1947

calculate weekdays

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 weekend days

ASP.NET

2504

Calculate a job End Date

by: Connie via AccessMonster.com | last post by:

Hi Access Building Friends, I am building a database for a manufacturer who needs to know the projected End_Date of each job. I know the Start_Date and the total days required to do the job. I need to calculate the End_Date after taking into account Weekends and Holidays.

Microsoft Access / VBA

3217

count days including weekend

by: Mike | last post by:

I have a routine that's calculating business days but its not counting the weekend days that are between the start date and end date. If my start date is 9/26/08 and my end date is 10/01/08, I should see 4 business days and 2 weekend days. How can I get that result? I'm getting 4 business days but its not counting the weekend days?

C# / C Sharp

24539

HowTo: Calculate business days - pure SQL approach.

by: FishVal | last post by:

IMHO, the following is not a how-to-do instruction to solve a particular problem but more a concept-proof stuff demonstrating possibilities of SQL. So, let us say the problem is to calculate business days count which is defined as count of days (optionally inclusive in the current implementation) excluding weekend days and holidays. Let us say periods to calculate are stored in table associated with contacts. keyPeriodID -...

Microsoft Access / VBA

8411

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8323

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8838

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8739

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7351

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6176

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4173

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4329

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1969

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP