Need help in load the data of last month

[#1]

Dear Friends,

In the Script as I need to Load the data of only last month the field name is "Statment Date" it contains DD/MM/YYYY format, now we are in July as I need to load the data of June Month Statment Date data.

I tried in Where condition as (MonthStart([Statment Date],-1) and MonthEnd([Statement Date],-1)), no result

Can anybody advise..

Regards

Chriss

[#2]

Hi Chris

try this:

LOAD date([Statment Date]) as [Statment Date],

     value

FROM (ooxml, embedded labels, table is Arkusz1) where Month([Statment Date])=month(today())-1;

[jonathandienst · Accepted solution]

Chriss

I think you need something like

     Where [Statment Date] >= MonthStart(Today(), -1) And [Statment Date] <= MonthEnd(Today(), -1)

Hope that helps

Jonathan

[#4]

Hello Jonathan,

Thanks a lot.... it works fine...

Regards

Chriss