FirstSortedValue, find last value before (or equal to) 08:00

[#1]

Hi,

need to find the last value before (or equal to) 08:00 but the below expression does not work properly, any ideas?

Pls find attached example files.

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

Rgds,

Olle

[Digvijay_Singh]

I think Settlement Time is in timestamp format, it might not work in set analysis when we compare it with value having time format(8:00..). that is the reason I added new field converted into time format in script. Also in source data there is 'dot' after seconds, so I think we need to use format 'hh:mm:ss.ffffff' with time# to interpret correctly though haven't checked yet if that makes much difference.