Monthly calendar

[#1]

Good morning friends,

I'm try to create a Monthly calendar based on date field (in this case called Fecha) but i can't. The problem is with "MakeDate", so is not possible to send Month Number in a variable.

Can any one help me please?

Thanks in advanced.

My script:

LOAD * INLINE [

    Fecha

    30-10-2015

];//

Mes_limites:

load MonthStart(Fecha) as MinDate,

  MonthEnd(Fecha) as MaxDate

  Resident TMP;

LET vMonth = num(Month( Peek('MinDate',0,'Mes_limites')));

LET vMaxDay = num(Day(vMaxDate));

Load Date(RecNo()-1+MakeDate(2015,"&(vMonth)")) as Date Autogenerate $(vMaxDay);

[Gysbert_Wassenaar · Accepted solution]

Maybe like this:

LOAD Monthstart(Date)+Iterno()-1 as Date

     While Monthstart(Date)+Iterno()-1 <= MonthEnd(Date);

LOAD date#(Fecha,'DD-MM-YYYY') as Date INLINE [

    Fecha

    30-10-2015

];

[#3]

Great gwassenaar

Works fine, thanks!!!