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 strongm 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: joanp
  • Order by date
  1. joanp

    Date Calculation in Query

    Never mind... I found it! %DateDiff(A.EFFDT,SYSDATE)
  2. joanp

    Date Calculation in Query

    Hi, I'm trying to return the number of days between SYSDATE and EFFDT in an expression in PS Query. I've tried: sysdate - a.effdt to_char(sysdate,'yyyy-mm-dd') - a.effdt and to_number(to_char(sysdate,'yyyy-mm-dd')) - to_number(a.effdt) All return error msg: SQL error. Stmt #: 4433 Error...
  3. joanp

    TestDirector-Customize 'Add a Defect' page

    Hi All, I'm trying to change the display order of the 'Add Defect' page (Setup Workflow > Script Generator - Field Customization for Add Defect). I drag the fields to where I want them displayed in the Visible Fields list and click on the Apply Script Changes button. When I open the Script...
  4. joanp

    Hiding Navigator (Business Process) Page

    Hi All, Can anyone tell me how to hide the Navigator page under the PeopleTools menu? The Navigator page is used to define business processes such as the pages needed to be completed during a New Hire process. We don't use it and don't want the end users to see it. We're on HRMS v8.3. I...
  5. joanp

    Locality codes in ps_local_tax_tbl

    These are locations that have multiple taxes... I is for income tax and O is for the Occupational tax.

Part and Inventory Search

Back
Top