Finding a date on a list

Jim Creak jim at
Sun Feb 14 20:55:19 UTC 2021

In Classic I would do

Calculate LD_Date as “"
Calculate #F as tot(FL_Trans,LD_Date.$assign(pick(TransDate<=SearchDate, LD_Date, pick(LD_Date < TransDate, LD_Date, TransDate)))


JACSoft Programming Ltd. <>
> On 15/02/2021, at 6:47 am, Martin Luce via omnisdev-en <omnisdev-en at> wrote:
> Hi All
> Help please
> I have a list of stock transactions with dates. I am trying to get the last transaction date which is less than or equal to the date I am looking at so that I can get what was in stock at the date I am searching on. I cannot see how to do it with notation on a list. I am sure that there must be a way.
> Many thanks
> Martin
> _____________________________________________________________
> Manage your list subscriptions at
> Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list