Finding a date on a list

Martin Luce martinluce at eclipse.co.uk
Mon Feb 15 10:41:27 UTC 2021


Thanks Jim

I did not try it as I got a simpler answer from Doug but many thanks for your help in replying

Martin

> On 14 Feb 2021, at 20:55, Jim Creak <jim at jacsoft.co.nz> wrote:
> 
> 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)))
> 
> Thanks
> Jim
> 
> JACSoft Programming Ltd. <http://www.jacsoft.co.nz/main.shtml>
>> On 15/02/2021, at 6:47 am, Martin Luce via omnisdev-en <omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>> 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 http://lists.omnis-dev.com <http://lists.omnis-dev.com/>
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com> 
> 



More information about the omnisdev-en mailing list