creating a calendar

[#1]

Hi,

    Am using the below script to create a calendar starting from 01/01/2012.

    it works fine but it also gives future dates.

    I just want to display starting from 2012 to till date.

    what changes are to be made?

LOAD  date(makedate(year(today())-1)-1+RecNo(),'MM-DD-YYYY') as [Link Date]

AUTOGENERATE (makedate(year(today())+1) - makedate(year(today())-1));

thanks in advance

sujay

[#2]

Hi,

Can you please attach your apllication.

[#3]

Hi nirmal

              i just want to create a calender from 01/01/2012 to till date.

this i am doing in the script of a qvd maker.

Later i am going to derive number of fields from [link date]

[MEllinghausen · Accepted solution]

AUTOGENERATE(date((today())) -yearstart(YearStart(Today())-1))

Marcus

[er_mohit]

LET vDateMin = Num(MakeDate(2012,1,1));

LET vDateMax = Num(Today());

TempCalendar:

LOAD

$(vDateMin) + RowNo() - 1 AS DateNumber,

Date($(vDateMin) + RowNo() - 1) AS datefield

AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

hope it helps

[#6]

Hi marcus

thanks for the reply.

everythings fine but its not giving 01/01/2012

i mean calender starts from 01/02/2012.

Jan 1st of 2012 is missing.

any suggestions?

sujay

[#7]

solved.