6 Replies Latest reply: Dec 5, 2014 6:46 AM by Martin Bacul�k RSS

    selection for last week

      Hi experts

       

      I have the following statement giving me entries of the last month:

       

       

      LOAD *, stunden_1w*stdsatz_alt1W as X_1w;

      Load

      jobnr,

          stunden as stunden_1w,

          stdsatz_alt as stdsatz_alt1W

       

      resident Stunden where datum > Date(AddMonths(Today(),-1));

       

      How can I get only values from last weeg?

       

      Best

       

      Jan