Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can define dynamically first date for Master calendar?
Thanks,
What do you mean with first date?
First selected? First sorted? Last value? Maximum date possible?
Regards, Marcel.
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;
Please see my attached file.
I want to make calendar, where I can select any time frame.
Thanks,
You mean to say Fiscal year calendar ?
No, regular year