Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have one calendar for year 2010 to 2013(till nov)
but i want to create it for Jan 2010 to Dec 2013.
i am using these variables
LET vDateMin = Num(MakeDate(2010,1,1));
LET vDateMax = ;
In my second i want to store DEC 2013 values..
how to do that
NOTE**** i don't want to Hardcode it
can any one help me......
Thanks in advance!!!!!
Smiley
Try Below
LET vDateMin = Num(MakeDate(2010,1,1));
LET vDateMax = Num(AddYears($(vDateMin),4)-1);
Best Regards,
Amey
Dear,
Use:
LET vDateMax = Floor(YearEnd(Today()));
calender script:
///////////////////////////////////////////////////////////////////
LET vDateMin = Num(MakeDate(2012,1,1));
LET vDateMax = Floor(YearEnd(Today()));
LET vDateToday = Num(Today());
TempCalendar:
LOAD
$(vDateMin) + RowNo() - 1 AS DateNumber,
Date($(vDateMin) + RowNo() - 1) AS TempDate
AUTOGENERATE 1
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);
Calendar:
LOAD
Date(TempDate) AS Date,
Month(TempDate) AS Month,
'Q' & Ceil(Month(TempDate)/3) AS Quarter,
Year(TempDate) AS Year
RESIDENT TempCalendar ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
Thanks,
Mukram.