Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement where i have to load always last 2 months data.I am unable to get the expected output withe below script.Can any one suggest me if I miss any thing below.
Sales:
LOAD * INLINE [
Dates, Sales
13-Jun-19, 10
15-Jul-19, 20
22-Aug-19, 25
11-Sep-19, 30
]
where Date(Date#(Dates,'DD-MMM-YY'),'MM/DD/YYYY')>'08/01/2019;
change where clause to below
where Date(Date#(Dates,'DD-MMM-YY'),'MM/DD/YYYY')>Date#('08/01/2019','MM/DD/YYYY');
or to make it more generic
where Date(Date#(Dates,'DD-MMM-YY'),'MM/DD/YYYY')> AddMonths(MonthStart(today()),-1);