Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QuartersMap:
MAPPING LOAD
rowno() as Month,
'T' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);
TempCalendarRange:
LOAD
date('01/01/2014') as MinDate,
date('31/12/2016') as MaxDate
Resident MainTable;
Let vMinDate = Num(Peek('MinDate', 0, 'TempCalendarRange'));
Let vMaxDate = Num(Peek('MaxDate', 0, 'TempCalendarRange'));
DROP Table TempCalendarRange;
TempCalendar:
LOAD Distinct
$(vMinDate) + IterNo()-1 as Num,
Date($(vMinDate) + IterNo() - 1) as TempDate
AutoGenerate (1)
While $(vMinDate) + IterNo() -1 <= $(vMaxDate);
MasterCalendar:
TempDate,
week(TempDate) as Week,
Year(TempDate) as Year,
Month(TempDate) as Month,
Day(TempDate) as Day,
YeartoDate(TempDate)*-1 as CurYTDFlag,
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
date(monthstart(TempDate), 'MMM-YYYY') as MonthYear,
ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
It's giving an error as if the variable vMaxDate is not created!
Can anyone see something wrong with this script?
Regards
Simão Ribeiro
This is the error that appears to me...
Help me please
What is your default date format? 'MM/DD/YYYY' or 'DD/MM/YYYY'? Only one is matching the MaxDate...
Both variables do not seem set correctly, so you need to first correct for this.
Maybe start with
/* commented out
*/
Let vMinDate = Num(Makedate(2014,1,1) );
Let vMaxDate = Num(Makedate(2016,12,31) );
//DROP Table TempCalendarRange;
Depending on how you configured is variable DateFormat at the beginning of the script.
SET DateFormat='DD/MM/YYYY';
If not configured, then it is the Date Format of the regional setting
