473,395 Members | 1,996 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,395 software developers and data experts.

Access 2007 adding a number of working days to a date

Good day,
I am working on an Access Database to manage production. I have created a table with all my deliverables. I have also created a query that calculates all my production delays, mainly with iff functions and very basic calculation. These delays are solid numbers. Now I need these numbers to translate into working days so I can add them to my reception date. For example: item A required 10 days of work, the item is received on the 1st of October 2013 so basically l want access to add 10 business days to the 1st of October.
I don’t know if I am clear... This is my fist time asking a question about IT on the internet. By the way, I really know nothing about VBA.
Thanks in advance!
Aug 27 '13 #1
3 3802
jimatqsi
1,271 Expert 1GB
Check out the Weekday function in VBA. It returns the day of the week for any date.

There is lots of built-in date calculation support in Access and VBA. Spend a while in the VBA Help that comes with Access.

A lot will depend on the level of precision you need. If you need to account for holidays you will end up building a table of dates that are holidays.

Jim
Aug 27 '13 #2
Rabbit
12,516 Expert Mod 8TB
If you need to account for holidays, you will need to create a table of holidays.
Aug 27 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: PK9 | last post by:
I have a loop where I need to calculate a series of dates based on: 1) a start date (DateTime variable) 2) a number of days (integer variable) I need to take the start date, then add the number...
5
by: BlackFireNova | last post by:
I need to write a report in which one part shows a count of how many total records fall within the working days (Monday - Friday) inside of a (prompted) given date range, in a particular...
29
by: james | last post by:
I have a problem that at first glance seems not that hard to figure out. But, so far, the answer has escaped me. I have an old database file that has the date(s) stored in it as number of days. An...
3
by: Jason Huang | last post by:
Hi, In our C# Windows Form application, we are using the SQL Server 2000 as the database server. The Database table MyTable has a field RegistrationDate which represents the Date a client comes...
0
by: kumarkanth | last post by:
My question is how do I manipulate the procedure to calculate cut-off date with in working days and it should skip weekends and holidays? I have holiday table to determine holidays Table Name :...
29
by: Santiagoa | last post by:
If I set up a task table with an Date_assigned and a number of days to complete the task I calculate the end_date field by using the code below I found in this forum How ever when I enter the...
0
by: John | last post by:
Hi I have problem with access 2007 application templates both included and from office online. None of them works. Every time there is a message like 'Table 'xxxxx' not found in ...may be...
17
by: ginajohnst | last post by:
Hi All. I'm having a problem adding days to a date. My date is in the string format dd/mm/yyyy eg. 23/08/2007 in my form field. I can't work out how to add 50 days to that date and then...
3
by: scan87 | last post by:
Hello everyone, I have a problem with my PHP code. I want to add specific number of days to the current date, so that it will display the correct date after adding the number of days to the...
2
by: sophiamb | last post by:
I am new to MS Access 2007. I'm working with an existing application, which is running off SQL Server and need to change the connection string so it works with a different database (on the same...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
Oralloy
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,...
0
jinu1996
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...
0
agi2029
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,...

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.