last date calculation

[jacek27031]

Hi, how to display in the table the minimum price of the last known day? Table name = [Prices], date is (date)

Thanks in advance for any help!

[anat]

Can u try using first sorted value function

[jacek27031]

Thx @anat ; are u able to send me the code example?