Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Max({<ID={'value'}>}[TimeDuration])
=Max({<ID={'$(=Max(ID))'}>}[TimeDuration])
=Max({<ID={'value'}>}[TimeDuration])
=Max({<ID={'$(=Max(ID))'}>}[TimeDuration])
Hi
In the front end, either of these two:
=Only({<ID={"$(=Max(ID))"}>} TimeDuration)
or
=FirstSortedValue(TimeDuration, -ID)
HTH
Jonathan
Thanks a lot, anbu's second suggestion worked!
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?
Use Max() for numeric fields
Use MaxString() for string fields