Maximo Open Forum

 View Only
  • 1.  Query using Start No Earlier Than

    Posted 13 days ago

    I am trying to write a query with Start No Earlier than Sysdate-7 and a Target Start Date of >=sysdate+14.

    I have "sneconstraint between sysdate-7 and sysdate",  but hat does not seem to work for the Start No Earlier Than date


    #Scheduling
    #WorkManagement

    ------------------------------
    Charlie
    ------------------------------


  • 2.  RE: Query using Start No Earlier Than

    Posted 10 days ago

    Hi Charlie, in your system information window, what is the database type?



    ------------------------------
    Steve Norris
    Cohesive
    ------------------------------



  • 3.  RE: Query using Start No Earlier Than

    Posted 2 days ago

    Sorry for the late response, Oracle 19.1



    ------------------------------
    Charlie
    ------------------------------



  • 4.  RE: Query using Start No Earlier Than

    Posted 2 days ago
      |   view attached

    Hi Charlie,

    See attached, you will have to change the siteid reference. If the dates do not line up, try changing the number of days reference for sysdate. As I do not have access to your system, please let me know if you experience any errors.



    ------------------------------
    Steve Norris
    Cohesive
    ------------------------------

    Attachment(s)

    txt
    MORE-Where Clause.txt   171 B 1 version