web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... X++ using maxof and mi...

Finance | Project Operations, Human Resources, ...

Suggested Answer

X++ using maxof and minof in the same sql statement

(0) Share

Report

Report

Posted on by JauB

352

Hi Everybody

How can we use at the same time minof and maxof in one sql statement ?

like doing select maxof(AccountingFate), minof(AccountingDate) from .... ?

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

You cant, result is saved into the field, so the easiest way is to do 2 select statements

Was this reply helpful? Yes No
Suggested answer

julianto1988 10 on at

Like (1)

Report

Hi,

I have faced the same requirement and I achieved by creating a view with string computed column.

public static server str MinAccountingDate()
{
tableName viewName = tableStr(View);

return SysComputedColumn::min(SysComputedColumn::returnField(viewName, identifierStr(viewDatasourceTable) , fieldStr(viewDatasourceTable.AccountingDate)));

}

public static server str MaxAccountingDate()
{
tableName viewName = tableStr(View);

return SysComputedColumn::max(SysComputedColumn::returnField(viewName, identifierStr(viewDatasourceTable) , fieldStr(viewDatasourceTable.AccountingDate)));

}

Was this reply helpful? Yes No
Suggested answer

JauB 352 on at

Like (0)

Report

Yes that's why I did, but wished to do it proprly .. !

Thanks

Was this reply helpful? Yes No
Suggested answer

JauB 352 on at

Like (0)

Report

Thanks Julian for your suggestion

Was this reply helpful? Yes No
Suggested answer

julianto1988 10 on at

Like (0)

Report

You're welcome, just let me know if you need more help..

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 664 Most Valuable Professional

#2

André Arnaud de Cal... 522 Super User 2025 Season 2

#3

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans