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

    If-statement with Dates

    Guy Vermeiren



      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,