Latest value of a field in Text Box

[chaper]

Hi,

      I am trying to display latest value (Based on Time Stamp) from a field in text box.I tried Max,FirstSortedvalue and Fieldvalue but not able to get latest instead i am getting oldest value.Need help?See below

I want to display latest Time Stamp value in text box.

Thanks in Advance.

[swuehl · Accepted solution]

Latest timestamp value:

=Max( TimestampField)

or

=Timestamp(Max(TimestampField))

If you want to get the another related field value based on latest timestamp:

=FirstSortedValue( OtherField, -TimestampField)

note the minus sign before Timestampfield to get the latest.

[Anonymous]

did you try

=timestamp(max(entered time stamp)

[chaper]

Thanks swuehl‌ .It works.I was trying before with FirstSortedValue( OtherField, TimestampField,-1). & FirstSortedValue( OtherField, TimestampField)  .minus did the trick.Thanks again

[chaper]

Thanks for Reply Rudolf.timestamp(max(entered time stamp) works for Time Stamp.But I am trying to get latest text field value  based on latest time stamp also.FirstSortedvalue with Minus before Timestamp worked.