Maximo Open Forum

 View Only

Related Content

  • 1.  Query using Start No Earlier Than

    Posted 01-24-2025 11:41

    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 01-27-2025 09:35

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



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



  • 3.  RE: Query using Start No Earlier Than

    Posted 02-04-2025 05:56

    Sorry for the late response, Oracle 19.1



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

    Original Message


  • 4.  RE: Query using Start No Earlier Than

    Posted 02-04-2025 11:09
      |   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