Hello,
I am using APEX 5 and I have a page with an Interactive Report. When using the "Actions" -> "Format" -> "Group by" option, is there a way to specify the use of MIN/MAX on a DATE column in the functions section of the Group By pop-up?
What I am attempting to do is to perform a query like the one below but via the Actions button:
select max(business_date)
, min(business\_date)
, account\_id
, sum(amount)
from my_table
group by account_id;
When you attempt to use the "Actions->Format->Group By" the only columns that appear in the Column list are of type number. There are no date columns in the drop down.
Thanks.