Please check the attached file.
date(DATE) as START_DATE,
month(date(DATE)) as START_MONTH,
'Q' & Ceil(month(date(DATE))/3) as START_QUARTER,
year(date(DATE)) as START_YEAR,
date(DATE) as END_DATE,
month(date(DATE)) as END_MONTH,
'Q' & Ceil(month(date(DATE))/3) as END_QUARTER,
year(date(DATE)) as END_YEAR,
(ooxml, embedded labels, table is EMP);
(ooxml, embedded labels, table is DEPT);
Start & End Dates.qvw 172.0 K
I used alternate states for Start and End date Multi boxes. Range Selection is shown In straight table(looking like a listbox!), I created set analysis based expression to build range from min date of multibox 1 and max date of multibox 2. Hidden one column of straight table to make it appear like a list box.
Expression used in straight table is -
- Where Start and End are alternate states.