Dynamically define first date for Master calendar

[Anonymous]

Hi,

How can define dynamically first date for Master calendar?

Thanks,

[marcel_olmo]

What do you mean with first date?

First selected? First sorted? Last value? Maximum date possible?

Regards, Marcel.

[#3]

Like this?

Temp_Calendar_Range:
LOAD
  Num(Date#(Min(MyDate), 'YYYYMM')) as MinDate
Resident [Main Data];

LET vMinDate = Peek('MinDate', 0, 'Temp_Calendar_Range');
DROP Table Temp_Calendar_Range;

[Anonymous]

Please see my attached file.

I want to make calendar, where I can select any time frame.

Thanks,

[#5]

You mean to say Fiscal year calendar ?

[Anonymous]

No, regular year