Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
For the master calendar, I am taking the minimum and maximum date date from my data and creating it. But now I want that irrespective of data, all the months and dates should be shown and there is no data then it should be grayed out.
For Example :
I have data from Jan 2015 to July 2015. Then all the months i.e. Jan to Dec should be shown with Aug, Sep, Oct, Nov and Dec greyed out like below:
instead of
don't use
Min(Date) and Max(Date)
but something like
YearStart(Min(Date)) and YearEnd(Max(Date))
as limits in your calendar script.
regards
Marco
don't use
Min(Date) and Max(Date)
but something like
YearStart(Min(Date)) and YearEnd(Max(Date))
as limits in your calendar script.
regards
Marco
or additionally load all months in a subsequent load like
LOAD Month(Date#(RecNo(),'M')) as Month
Autogenerate 12;
hope this helps
regards
Marco