1 Reply Latest reply: Jan 30, 2018 6:05 PM by Marco Wedel RSS

    FOR Each loop using months

    Karan KN

      Can some one help me to write For Each loop for the below script, as we have to run data Jan 2018, Feb 2018, Mar 2018.......

       

      Table1:

      LOAD CustID,

                 Sales_Date

      FROM

      Inventry.xlsx

      (ooxml, embedded labels, table is Sheet2)

      Where Sales_Date>=MonthStart(Today()) and Sales_Date<=MonthEnd(Today());