This content has been marked as final. Show 4 replies
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