Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
we need to from todays date generetaet 12 month date and year .pls help me
Hi,
add this.
'Q' & Ceil(Month(Date)/3) & '/' & Year(Date) AS Qurter
Regards,
Kaushik Solanki
we need to from todays date need generetaet last 12 month date and year .pls help me
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
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.
Hi,
add this.
'Q' & Ceil(Month(Date)/3) & '/' & Year(Date) AS Qurter
Regards,
Kaushik Solanki
wow !!!! it is working thx Kaushik......bit bussy last week..not able to reply..
Hi,
Glad to help..
Regards,
Kaushik Solanki
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;