Automate

  • 1.  Winshuttle Query - Constraining dates

    Posted 05-01-2021 01:18

    Hi
    Wondering what the best practice is for extracting Winshuttle queries for a specific date range. I am trying to extract internal orders from table AUFK that have a release date that is greater than 1 year old. Is there a best practice suggestion?. 



    ------------------------------
    Ash Singh | Business Systems Improvement Manager

    ------------------------------


  • 2.  RE: Winshuttle Query - Constraining dates

    Posted 05-03-2021 09:30
    Hi Ash -

    For date fields in Query, you will see different options that allow you to dynamically change the number of days value. In my example below the operator is less than and it's looking for Release Date that is less than Today minus 365 days, so older than 365 days ago from whatever the run day is.  


    Thanks!


    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------

    Original Message