Master calendar generates only 31/12/1899 date issue

[Anonymous]

Hi All

Below is my master calendar script which generates only 31/12/1899,it should generate dates between 01/01/2000 to today.:

LET vMaxDate = Today();

LET vMinDate = date(Num(MakeDate(2000,1,1)));

QuarterMap:

MAPPING LOAD * INLINE [

    Month, Quarter

    7, Q3

    8, Q3

    9, Q3

    10, Q4

    11, Q4

    12, Q4

    1, Q1

    2, Q1

    3, Q1

    4, Q2

    5, Q2

    6, Q2

];

MasterCalendar:

LOAD

  Date,

  Week(Date) AS Week,

  Year(Date) AS Year,

  Month(Date) AS Month,

  Day(Date) AS Day,

  WeekDay(Date) AS WeekDay,

  applyMap('QuarterMap', num(month(Date)),'unknown qtr') AS Quarter,

  Date(monthStart(Date), 'MMM-YYYY') AS MonthYear,

  dual(Week(Date)&'-'&WeekYear(Date),WeekYear(Date) & num(Week(Date),'00')) AS WeekYear

  ;

LOAD

  Date($(vMinDate) + RecNo() - 1) AS Date

AUTOGENERATE ($(vMaxDate) - $(vMinDate)+1);

please any help will be appreciated.

Thanks

Neetha

[sunny_talwar · Accepted solution]

Try this:

LET vMaxDate = Num(Today());

LET vMinDate = Num(MakeDate(2000,1,1));

[sunny_talwar]

Sample application attached.

HTH

Best,

Sunny

[Anonymous]

missed that one.

Thanks for help

[sunny_talwar]

Not a problem

Sunny