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!

       

      Jan