Date

[#1]

Thanks in Advance

Madhu

[sujeetsingh]

Use make date function and Auto script to create dates

follow this Creating A Master Calendar

[Peter_Cammaert]

What is your question?

BTW the NEXT keyword is missing at the end of your script.

[Kushal_Chawda]

try

let vMinDate = MakeDate(2015,01,01);

LET vMaxdate = MakeDate(2015,01,31);

LOAD date('$(vMinDate)'+IterNo()-1,'DD/MM/YYYY') as Date

AutoGenerate(1)

While '$(vMinDate)'+IterNo()-1 <= '$(vMaxdate)';

[tresB]

Load

  Date(MakeDate(2015,1,RowNo())) as Date

AutoGenerate 31;

[Gabriel]

Hi,

Try this code

FOR i = 1 TO 30

    LET vDate = MakeDate(Year(Today()),$(i),$(i));

    Case_Data:

    LOAD

     MONTH('$(vDate)')        AS  Case_Month,

     DATE('$(vDate)')        AS Case_Date

AutoGenerate (1)

;

NEXT i;