Master Calender Script

Hi All,

Below script helps in generating the Master calendar.

Hope this will help you.

LET vDateMin=num(makedate(2016,01,01));

LET vDateMax=floor(monthend(today()));

LET vDateToday = num(today());


LOAD Distinct Date($(vDateMin) + RowNo() – 1,’DD-MMM-YYYY’) AS Date,

month(Date($(vDateMin) + RowNo() – 1,’DD-MMM-YYYY’)) AS Month,

year(Date($(vDateMin) + RowNo() – 1,’DD-MMM-YYYY’)) AS Year,

monthname(Date($(vDateMin) + RowNo() – 1,’DD-MMM-YYYY’)) AS Monthname,

Week(Date($(vDateMin) + RowNo() – 1,’DD-MMM-YYYY’)) AS Week


AutoGenerate 1 While $(vDateMin) + IterNo() – 1 <=$(vDateMax);



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.