Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jms1
  • Order by date
  1. jms1

    Differnce between two dates in business days

    I am currently using version 9. HEre is the formula I am using:- If wdaysClass1wdNumWorkDays (datevalue ({MPD_Manuals.ManualRequiredDate}), datevalue ({MPD_Manuals.DateCompleted}), "-23456-") = 0 then Formula = 0 Else Formula = wdaysClass1wdNumWorkDays (datevalue...
  2. jms1

    Differnce between two dates in business days

    Hi everyone, I can calculate the number of business days between two dates. If the release date is after the requried date eg late I get the correct number of working days, but In this instance the release date is before the required date eg released early(eg the required date of 1/1/04 and...
  3. jms1

    Adding x Working Days to a specific date

    I want to add a leadtime eg 10 working days to an order date. I can add 10 calendar days using the DateAdd function DateAdd("d", 10, #Sept 28, 1999#)but need to know how to add 10 weekdays.
  4. jms1

    Week numbers and dates

    You will find a good solution to this on the Crystal Decisions website.

Part and Inventory Search

Back
Top