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 biv343 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. sat6845

    maximim for the two different date and then maximum of those two date

    Help!!. My objective to find the maximim of date1 first and find the maximim of date 2 and then the maximum of above maximim First I had to find Maximim of Date 1 and the MAximim of Date 2 for an ID and then find the which is greater betwen those to maximim date I had to Field Date1 and Date2...
  2. sat6845

    Help Regardig the CASE statemet

    thank you bot I will do the same
  3. sat6845

    Help Regardig the CASE statemet

    Can any one help to create the case statement here is if/else statemet? IF NOT ISNULL({Command.HR_ASSESSMENT_DT}) THEN IF {Command.90_DAYS} = "N" THEN IF {Command.HIGH_RISK_IND} = "ASSESED HIGHRISK" THEN "1B" ELSE "1C" ELSE IF {Command.HIGH_RISK_IND} = "ASSESED HIGHRISK"...
  4. sat6845

    Date formula....set to "" if it is 01/01/1990

    if date({Command.START_DT}) = date('1/1/1900') then date(0,0,0) else {Command.LATEST_COP_START_DT} it will display nothing....if the date is '1/1/1900'
  5. sat6845

    cross-tab question

    Hi. I need to put this information in the cross tab. After calulating here is the data looks in the detail. ITEM|Received Date - Approved in week - Despatch within week xx 1/1/2005 2 4 x1 1/2/2005 1 1 Approved in week...
  6. sat6845

    how to combine report group resaults in on line horisontaly

    Hi. I need to put this information in the cross tab. After calulating here is the data looks in the detail. ITEM|Received Date - Approved in week - Despatch within week xx 1/1/2005 2 4 x1 1/2/2005 1 1 Approved in week...

Part and Inventory Search

Back
Top