Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
please find the my attached Excel file.
I have one Excel sheet one having DATE field dates from Jan1 to Jan30 and Sheet2 having TWo fields STARTDATE and ENDDATE.
STARTDATE ENDDATE
Jan5 Jan20
i want now dates from sheet1 Jan5 to Jan20
Expected Output:-
Jan5
-
-
-
-
-
-
Jan20
Check Here ..Date
Please don't clutter this site with duplicate discussions: Date
Hello Mahesh,
this should work
DateRange:
LOAD StartDate,
EndDate
FROM
(
LET varMinDate = num(Peek('StartDate',-1,'DateRange'));
LET varMaxDate = num(Peek('EndDate',-1,'DateRange'));
drop table DateRange;
Calender:
LOAD
num($(varMinDate)+rowno()-1) AS DateNumber,
date($(varMinDate)+ rowno() -1, 'MMMDD') AS TempDate
AUTOGENERATE
$(varMaxDate)-$(varMinDate)+1;
Check Here ..Date
Hi Tim Driller,
thanks for support,i got the output.
Regards,
Mahesh.