date

[srinivasa1]

we need to from todays date generetaet 12 month date and year .pls help me

[srinivasa1]

we need to from todays date need generetaet last 12 month date and year .pls help me

[kaushiknsolanki]

Hi,

   Do you mean you want to create a master calander from last 12 months till now.?

   If yes then try following code.

   Let vMin = num(Makedate(2011,01,01));

   Let vMax = num(today());

   Temp:

    Load

      Date($(vMin) + Iterno() -1) as Date

    Autogenerate 1

    While Date($(vMin)) + Iterno() -1 <= $(vMax);

    MasterCal:

    Load Date,

    Month(Date) as month,

    Year(Date) as Year

    Resident Temp;

    Drop table Temp;

Regards,

Kaushik Solanki

[srinivasa1]

hey i think it will help full to me. i need qurter also in this can you pls guide me.will get back to you about ur ans.

[kaushiknsolanki · Accepted solution]

Hi,

   add this.

   'Q' & Ceil(Month(Date)/3) & '/' & Year(Date) AS Qurter

Regards,

Kaushik Solanki

[srinivasa1]

wow !!!! it is working thx Kaushik......bit bussy last week..not able to reply..

[kaushiknsolanki]

Hi,

    Glad to help..

Regards,

Kaushik Solanki

[dseelam]

Hi Kaushik,

   The below statement working perfectly alright but does the past 12 months will be changing daily once the script is reloaded ?

   Let vMin = num(Makedate(2011,01,01));

   Let vMax = num(today());

   Temp:

    Load

      Date($(vMin) + Iterno() -1) as Date

    Autogenerate 1

    While Date($(vMin)) + Iterno() -1 <= $(vMax);

    MasterCal:

    Load Date,

    Month(Date) as month,

    Year(Date) as Year

    Resident Temp;

    Drop table Temp;