6 Replies Latest reply: Oct 18, 2011 3:07 AM by Guy Vermeiren RSS

    If-statement with Dates

    Guy Vermeiren

      Hello,

       

      I'm working with 2 dates. If I add a Calculated dimension like

       

      [SalesDocumentConfirmedScheduleLine.Delivery date]-Today() I get a perfect result in days

       

      Now I would like to eliminate a number of records by "Suppress when Value is Null" and as expression

       

       

      If([SalesDocumentConfirmedScheduleLine.Delivery date]-Today() > 0, Null())

       

      but this doesn't -seem to work.

      For alle values I get a Null()

      Any suggestions ?

      Thanks in advance.

      Kind regards,
      Guy