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());

[MarcoWedel]

What's your expected result here? You might be able to achieve your reuirements without loops.