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 derfloh 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. amyceres

    Days of the week except Sunday and Holiday

    I reason I want to do this is because I want to know the number of days between {lt_master.lock-exp-dt} and the current date.
  2. amyceres

    Days of the week except Sunday and Holiday

    ...Date (2015,11,11), Date (2015,11,26), Date (2015,12,25)];; Weeks:= (Truncate (End - dayofWeek(End) + 1 - (Start - dayofWeek(Start) - 1)) /6 ) * 5; Days := DayOfWeek(End) - DayOfWeek(Start) + 1 + (if DayOfWeek(Start) = 1 then -1 else 0)+ (if DayOfWeek(End) = 7 then 1 else 0); if...
  3. amyceres

    Excel formula to Crystal

    This is my excel formula =IF(D6="","",IF(D6="Purchase",TEXT(WORKDAY(E6,1,Holidays),"DDDD"),IF(D6="Refinance",TEXT(WORKDAY(A6,4,Holidays),"DDDD")))) I trying to find out how I would convert this into crystal report.
  4. amyceres

    Convert date to number or general format?

    whoohoo they both work perfectly...thanks for the help
  5. amyceres

    Convert date to number or general format?

    I am not using VBA but I am using Crystal Reports.
  6. amyceres

    Convert date to number or general format?

    Yes I want to know how to convert the date to a general number...
  7. amyceres

    Convert date to number or general format?

    4/22/13 + 60 would be 6/21/13 but I wanted it in general format or number format
  8. amyceres

    Weekends and Holiday

    thank you for the information...I found that I probably going to include the holiday in the @weekend formula because I am not getting the result that I want from keeping everything separate.
  9. amyceres

    Convert date to number or general format?

    I want to convert ({currentdate}+ 60)to a number format.. so it would be 4/22/13 +60 = 41446..I been searching through the forum and I haven't gotten a clear answer. So say use a datevalue() or a dateserial() but either of them work.
  10. amyceres

    Weekends and Holiday

    I placed the formula in the Record Selection like you said to and it works!!!Thanks! but the @Holiday formula was suppose to be inserted into the Report Header in the Design View? I don't think that would work because it shows nothing.
  11. amyceres

    Weekends and Holiday

    ...and Not(WeekDay({lt_master.application-dt}) in [1, 7]) Weeks:= (Truncate (End - dayofWeek(End) + 1 - (Start - dayofWeek(Start) + 1)) /7 ) * 5; Days := DayOfWeek(End) - DayOfWeek(Start) + 1 + (if DayOfWeek(Start) = 1 then -1 else 0) + (if DayOfWeek(End) = 7 then -1 else 0); Local...
  12. amyceres

    Weekends and Holiday

    It's a in house software database program that we used called Unifi.
  13. amyceres

    Weekends and Holiday

    All the information I pulled is from CVS file.
  14. amyceres

    Weekends and Holiday

    Please give me information? or examples?
  15. amyceres

    Date and Time Calculation

    Question would you be taking holidays into consideration?
  16. amyceres

    Weekends and Holiday

    ? Anybody?
  17. amyceres

    Weekends and Holiday

    Yes, there would be data for weekends and public holidays that would need to be ignored and I would only need data for Monday- Fridays unless there is a holiday any of those days. Short of listing all 104 dates for the weekends to ignored what is an easier way? Thank you
  18. amyceres

    Subreport

    When a report is upload into in Business Object and it is run and it has a subreport in the report footer would the subreport also refresh at the same time?
  19. amyceres

    Weekends and Holiday

    I have most of the stuff solved for this problem however, now that I don't count the weekend, when Friday roll around the weekend days are included in the report now. and I only want the weekday reports excluding the Holiday. Today I pulled up the reports for currentday. 4/5/13 I only want...
  20. amyceres

    Weekends and Holiday

    ...NumberVar Days; Local Numbervar Hol; DateVar Array Holidays; Weeks:= (Truncate (End - dayofWeek(End) + 1 - (Start - dayofWeek(Start) + 1)) /7 ) * 5; Days := DayOfWeek(End) - DayOfWeek(Start) + 1 + (if DayOfWeek(Start) = 1 then -1 else 0) + (if DayOfWeek(End) = 7 then -1 else 0)...

Part and Inventory Search

Back
Top