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!

  • Congratulations SkipVought 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: *

  1. peggysuebaker

    Crystal Reports Select and Count

    Example of what I currently have: Date/ Reason 1 / Count (of reason 1) Date/ Reason 2 / Count (of reason 2) Date/ Reason 3 / Count (of reason 3) what I would like is Date/ Reason / Count (of reason 1, 2, and 3 together) Not sure how to do this and what to...
  2. peggysuebaker

    Calculating the number of Business Days between two dates

    After much searching on the web I was able to get an answer from our IT department in Tallahassee that worked. I thought I would share so if anyone else looks for this it may help them. Thanks again for all your efforts. Local NumberVar DayCount; Local NumberVar WorkDays; //List of 10...
  3. peggysuebaker

    Calculating the number of Business Days between two dates

    I am placing my code again so you can see changes made. I have then placed a sampling of the data I receive back. As you will see it is not correct. Subtracting Attempt Date from Date Received 7/13/2011 - 7/12/0211 is giving result of -5. I am getting different value when it is only one day...
  4. peggysuebaker

    Calculating the number of Business Days between two dates

    That worked, thanks so much. But, now it gives me "true" instead of the number of days. How do I get the actual number?
  5. peggysuebaker

    Calculating the number of Business Days between two dates

    I have my formula below. I copied this from faq767-4465 posted 21 Nov 03. I get an error saying "date-time is required" here for the StartDate field I am using. It shows as a date field in Crystal so I'm not sure what I am suppose to do now. I usually make very basic reports so please try to...

Part and Inventory Search

Back
Top