Find FirstSortedValue, sort by Timestamp

[#1]

Hi,

need to find the first sorted value but the below expression does not work for some reason. Something with the timeformat i suppose. 

FirstSortedValue({<SettlementTime={'<08:00:00:000000'}>} RunningBalance,SettlementTime)

Pls find example files attached.

Regards,

Olle

[pokassov · Accepted solution]

Hi!

FirstSortedValue({<SettlementTime={'<$(=time(08:00:00:000000))'}>} RunningBalance,-SettlementTime)

[#3]

gr8 thanks!!