Please allow the Max and Min query methods in Query Objects to support DateTimes and their variations and not restricted to just numeric data types. If this is based on SQL, SQL allows max and min on datetimes and strings. If that is not possible can new methods like MaxDate and MinDate be added?
Comments
My vote for this idea, this could be really useful. For example, a simple task like finding the first/last sales date for an SKU sometimes requires hundreds of thousands of database queries, since we have to query each combination of item/variant/location separately. SELECT MIN([[Posting Date]) with GROUP BY would be much more efficient.
Category: Development
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team