Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD * INLINE [
startdate, enddate
20/07/2015, 30/07/2015
];
date1:
load date(Date#(startdate,'DD/MM/YYYY'),'MM/DD/YYYY') as start_date,
date(Date#(enddate,'DD/MM/YYYY'),'MM/DD/YYYY') as end_date
resident date;
drop table date;
let stratdate1=num(peek(start_date));
let enddate1=num(peek(end_date));
load date($(stratdate1)+IterNo()-1) as startdate1
AutoGenerate 1
while IterNo()<= ($(enddate1) - $(stratdate1));
My problem resolved i missed ' ' in peek function thanks for replying
Hi ranganna
If your issue is resolved please close thread by selecting Correct Answer