topic Re: I want to show MAE_Type at Max(MAE_CreateDate) in App Development

I want to show MAE_Type at Max(MAE_CreateDate)

Sxbbb — Fri, 15 Nov 2024 21:10:05 GMT

I Have Data

I want to show MAE_Type at Max(MAE_CreateDate)

I tried but it's not correct :

Re: I want to show MAE_Type at Max(MAE_CreateDate)

Anil_Babu_Samineni — Tue, 19 Dec 2023 05:51:00 GMT

Not sure the idea why you want to show Max. Anyway, since this filed contains string, Maybe

MaxString(MAE_CreateDate)

Re: I want to show MAE_Type at Max(MAE_CreateDate)

Sxbbb — Wed, 20 Dec 2023 02:33:17 GMT

I want to display the latest MAE_Type. can see it from MAE_CreateDate.

EX FT_ID = 20110324 The latest MAE_Type is Dismantle.

I tried

The displayed value is correct.

However, if FT_ID is not selected, the value will not be displayed.

Re: I want to show MAE_Type at Max(MAE_CreateDate)

Sivapriya_d — Wed, 20 Dec 2023 11:04:32 GMT

Can you please provide more details like expected output table i.e expected columns and are you expecting to display only the latest date for FT_ID with latest MAE_Type.