display load time where ID = something

[#1]

Hi I am trying to display time in A TEXT BOX corresponding to latest load. How could I achieve that?

In SQL, query would be something like:

SELECT      [TimeDuration]

FROM          [TABLE]

WHERE      [ID]  = (SELECT MAX(ID)

                                FROM

)

[anbu1984 · Accepted solution]

=Max({<ID={'value'}>}[TimeDuration])

=Max({<ID={'$(=Max(ID))'}>}[TimeDuration])

[jonathandienst]

Hi

In the front end, either of these two:

=Only({<ID={"$(=Max(ID))"}>} TimeDuration)

or

=FirstSortedValue(TimeDuration, -ID)

HTH

Jonathan

[#4]

Thanks a lot, anbu's second suggestion worked!

[#5]

Hi anbu, your suggestion works where the field is numeric, however for some reason it doesn't work where my field is a string. Could you pls help with that?

[anbu1984]

Use Max() for numeric fields

Use MaxString() for string fields