1 Reply Latest reply on Mar 15, 2017 11:23 AM by Mithil Mangalore

    Create a new column based on one date being between two dates

    Mandy Washington

      I am trying to create a new column in my sample dataset called "holiday" based off of start and end dates in my other sample dataset. I keep getting 'no holiday' which i know is wrong:

       

      if ATTR([Order Date]) >= ATTR([Sheet1 (Holiday Sample Test)].[start Date])

      or ATTR([Order Date]) < ATTR([Sheet1 (Holiday Sample Test)].[End Date])

      then ATTR([Sheet1 (Holiday Sample Test)].[Holiday])

      else 'no holiday'

      end

       

      can anyone help me with this?