4 Replies Latest reply: Mar 28, 2014 1:52 PM by Marco Wedel RSS

    If Syntax

    Isabel Nowinowski

      Hello,

              If I am trying to determine whether a SKU falls into an Event labeled by Flyer during a particular week, should I do this as an if statement or a set analysis?

       

      I can determine whether or not the SKU is part of a flyer event with the following:

       

       

       

      if([Event] like '*Flyer*','Yes')

       

      However, how do I incorporate a particular week that is dynamic into that expression? I am specifically trying to find whether or not the SKU is part of a flyer event between max([PO Rec Date]) and max([PO Rec Date])+6

       

      Thanks!