4 Replies Latest reply: Oct 31, 2014 11:12 AM by Jan Heinrichsdorff RSS

    where expression with current year

      Hi experts


      I would like to load data but only data from the current year. this is my expression:


      resident job where Jahr = 2014 group by prodnr;


      How can I define the current year instead of hardcoding it?


      Additionally, I would like to load data from last year but only until the current date last year.


      How would I habe to script this?


      Thank you very much for your help!