help needed with master calendar

[#1]

Hi All,

    I am trying to create master calendar starting from last year to previous month of this year.

    any help would be appreciated

    FYI...

[tresesco]

Try like:

let VMinDate=MakeDate(2014,01,01);
let VMaxDate=MonthStart(Today());

MasterCalendar:
Load  Date($(VMinDate) + RecNo()) as TempDate
  AutoGenerate VMaxDate-VMinDate ;

[#3]

Hi Tresesco,

     i have tried that and iam getting a strange year field like 1905,1906..

[senpradip007]

Try like:

let VMinDate=Num(MakeDate(2014,01,01));
let VMaxDate=Num(MonthStart(Today()));

MasterCalendar:
Load  Date($(VMinDate) + RecNo()) as TempDate
  AutoGenerate VMaxDate-VMinDate ;

[tresesco · Accepted solution]

Sorry, add num() like:

let VMinDate=Num(MakeDate(2014,01,01));
let VMaxDate=Num(MonthStart(Today()));

MasterCalendar:
Load Date($(VMinDate) + RecNo()) as TempDate
AutoGenerate VMaxDate-VMinDate ;

[#6]

Tq guys...

[jagan]

Hi Sruti,

Try this script

let VMinDate=Num(MakeDate(2014,1,1));

let VMaxDate=Num(MonthStart(Today()));

MasterCalendar:

Load  Date($(VMinDate) + RecNo() -1) as TempDate

AUTOGENERATE (Num(Interval(VMaxDate-VMinDate, 'D')));

Regards,

Jagan.