FOR Each loop using months

karan_kn — Tue, 30 Jan 2018 16:15:36 GMT

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

Re: FOR Each loop using months

MarcoWedel — Tue, 30 Jan 2018 23:04:49 GMT

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