4 Replies Latest reply: Sep 21, 2011 9:08 AM by stefano santini RSS

    show dates up to today

      I´m trying to show dates up to today in a document, and I have this code as a calculated dimension:

       


      This works to get all dates from 2011-01-01 up to today. But I would like to use makedate(max(year)) or similar to get start of year instead of using '2011-01-01'.

      But if I try to use for example if(Date >= makedate(max(Year)) AND Date <= today(), Date) I get an "error in calculated dimension".

       

      I need some input in how to solve this.

      Best regards

      Anders

      if( Datum >= '2011-01-01' AND Datum <= today() ,Datum)