1 Reply Latest reply: May 14, 2015 12:32 PM by Gysbert Wassenaar RSS

    Set Analysis in LookUp Function

    Lin Yur

      What is the syntax to add set analysis to the below statement? I do not want the lookup feature to operate if [Delivery No.] = 'Result' . I'm not sure how to incorporate that into the syntax.



      date#(WeekEnd(Lookup('Delivery_Date', 'Delivery_ID', [Delivery No.], 'Delivery_Date'), 0,2),'MM/DD/YYYY') as 'ActionDate'



      Thank you for the help!