need to create master calender from current date

[Karim_Khan]

Hi Team,

   I am planning to create the master calendar from today's date which will show me 100 years data.past 50 years and future 50 years.

Can we achieve the same through single data suppose today's date is 02-06-2016.

    Now I want to show the data from 1950 to 2049 and in this I will show the least granularity values of date?

Regards,

KK

kush141087‌shubham.kumar‌sureshqv‌ashfaq_haseeb‌@manish kacchia

[Kushal_Chawda]

Do you need all the Dates for 100 Years of Data?

[MindaugasBacius · Accepted solution]

Try using this script:

varMinDate = addyears(Today(), -50) ;
varMaxDate = addyears(Today(), 50);

tmp:
LOAD
  DATE($(varMinDate) + ROWNO() - 1) AS Date
AUTOGENERATE ($(varMaxDate)-$(varMinDate) + 1);

Calendar:
LOAD
  Date
RESIDENT tmp;

DROP TABLE tmp;

[Karim_Khan]

s

[avinashelite]

change the min and max date and follow the below post

Creating A Master Calendar