2 Replies Latest reply: Jun 2, 2016 11:43 AM by Neena Bhattarai RSS

    IF then statement with > and < in expression.

    Neena Bhattarai

      I am trying to create a table that displays the customer whose last purchases was 12 months ago to 23 months ago. This is the expression I am trying to use:

      =IF(Max(Date(Today()))-Max([Order Date])>367<763, [Bill To Name])

      However, I am getting no data using this. How can I use the greater than and less than symbols in an expression for a straight table? Any help is appreciated!