Search results

Notes: no weekends or holidays and the first day is always day zero...even if falls on saturday or sunday.

Thanks... Public Function PlusWorkdays(dteStart As Date, intNumDays As Long) As Date PlusWorkdays = dteStart Do While intNumDays > 0 PlusWorkdays = DateAdd("d", 1, PlusWorkdays) ' If Weekday(PlusWorkdays, vbMonday) <= 5 Then '-- If you have a Holiday Table use the next IF instead...

Quick Question: This works great on Monday through Friday where if something is picked up on Monday and is to deliver on Friday and the transit time is 4 days. However if picked up on Sat/Sun, Monday should be day zero. Can you help me alter this code to reflect that? THANKS!!

Did that, but now when I open the query...RunTime error '3078. Cannot find tblHolidays.

How do I do that? Sorry, still learning.

This works great, but after I split...causes tons of latency. Any suggestions?

Do you have any suggestions for excluding just sundays?

Disregard...it works!!!! THANK YOU

Thanks, I changed by table to match your code. tblHolidays and field HoliDate. Now I am getting a compile error. Thoughts. Sorry new at this...

I copied this into module. I received a Compile Error. Here is the code. Public Function PlusWorkdays(dteStart As Date, intNumDays As Long) As Date PlusWorkdays = dteStart Do While intNumDays > 0 PlusWorkdays = DateAdd("d", 1, PlusWorkdays) ' If Weekday(PlusWorkdays, vbMonday) <= 5...

Any suggestions and best practices on the following. I have commit times (which are days). I need to calc the end date based on a start date and the number of days added. Excluding weekends and 10 us holidays. Example. Start date is 9/7 and needs to be delivered in 6 days. So I need to...

Trying to count records in a field CUST. These records will be separated by a comma and sometimes the field will be blank. i.e. CUST REF 80908766, 723767676, 787987987 23432434, 342343432 I want to show that there is 3 entries in that field for the first record and 2 entries in that field...

I have a linked table in access to sharepoint. I am trying to run an update query to update one field. It worked, until I had to rewrite the query. I didn't change anything as far as format, what could cause a lock violation issue? Any help is appreciated.

Sorry, his tone was completely off and I took it the wrong way. 1. What letters are likely to come out? any combination 2. Where do they come from? (from another field, user input, what?) same field. 3. What happens if there is a null for that field? keep null 4. Do the letters always...

All I am doing is asking for help. you should think about what you say before you write it. Tone means everything, especially in this setting.

Thought about that, but not all will be specific to JFK, could be ATL, MIA,etc. Shannon

I have data that looks like this '006JFK74901702' and I want to remove the JFK. Sometimes the field can be null. How do I remove?

Do you have any suggestions?

Suggestions?