Calculate Max Value Between Two Timestamps

[salerik]

Hello.

I have a column with timestamps and another column of values.  I am looking to determine the maximum Value between the last (max) Timestamp and 24 hours ago.  I am having trouble writing an expression for this.  Can you please help?  Thank  you.

[sunny_talwar]

What have you tried so far? Can you share some sample data and the output expected from it?

[sunny_talwar · Accepted solution]

Although you can try something like this

Max({<TimeStampField = {">=$(=TimeStamp(Max(TimeStampField) - 1, 'TimeStampFieldFormatHere'))<=$(=TimeStamp(Max(TimeStampField), 'TimeStampFieldFormatHere'))"}>} Value)