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 Rhinorhino 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: amyceres
  • Content: Threads
  • Order by date
  1. amyceres

    Days of the week except Sunday and Holiday

    I am trying to exclude the Sundays and holidays. I think this is correct but I am not really sure. Local DateVar Start := {lt_master.lock-exp-dt}; Local DateVar End := currentdate; Local NumberVar Weeks; Local NumberVar Days; Local Numbervar Hol; DateVar Array Holidays:=[ Date (2013,1,1)...
  2. 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.
  3. 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.
  4. 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?
  5. amyceres

    Weekends and Holiday

    I know that this formula been touch on over and over again but I need help and solving this glitch in my formula There is three parts to this problem This is what I have currently.. For the @ Holidays I have this formula below however, when I check the formula for errors it keep saying that...
  6. amyceres

    if else statement in Excel is not reflected correctly in Crystal?

    Can somebody help with this formula? Excel formula =IF(lt-master.loan-purpose="","",IF(AND(lt-master.loan-purpose="Purchase",F2=""),lt_master.application-dt + 90,IF(AND(lt-master.loan-purpose="Purchase",@Sale Contract Received Date >0),@Sales Contract Closing Date,IF(lt-master.loan-purpose="...

Part and Inventory Search

Back
Top