Master Calender

[rash_611]

Hi,

I want to create a master calender where the date range is as below.

Jan 26 to Feb 25 ---- Jan Calender

Feb 26 to Mar 25 ---- Feb Calender

Mar 26 to Apr 25 ---- Mar Calender

Can any one help me on this....

Regards,

Grace

[Alejandro_Hernández]

is this what you need?

set DateFormat='M/D/YYYY';

Let vStart = date('12/31/2013');

Let vEnd = date('12/31/2014');

Load Month(Date) as MonthName, date(Date+25) as Date ;

Load Date('$(vStart)' + RecNo()) as Date autogenerate '$(vEnd)' - '$(vStart)' ;

[#3]

i think u can use  MakeDate function

for a Creating date

makedate(1999,2,14) returns 1999-02-14

[jagan]

Hi,

Try this

Let vStart = date('1/26/2014');

Let vEnd = date('4/25/2014');

Calendar:

Load

     If(Date >= Date('1/26/2014') AND Date <= Date('2/25/2014'), 'Jan',

          If(Date >= Date('2/26/2014') AND Date <= Date('3/25/2014'), 'Feb',

          If(Date >= Date('3/26/2014') AND Date <= Date('2/25/2014'), 'Mar', Month(Date))) AS MonthName,

     Date ;

Load

     Date('$(vStart)' + Iterno() - 1) as Date

autogenerate '$(vEnd)' - '$(vStart)' ;

Regards,

Jagan.