2 Replies Latest reply: May 15, 2014 9:57 AM by Oli _ RSS

    calcualting with dates

    Oli _

      I have to calculate the today date - a given date (comes from a lookup-file). If this result is less than 6 months there should be diplay "X"

       

      I tried it in that way:

       

      IF(Today()-[New customer]>180;"X";0)

       

      is a date comes from a lookup file.

       

      Who can I say Monarch the period between 2 dates? In the example above I tried it by given the day range, but it doesn't function.

       

      Regards

      oli