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.