Find date in a range of records

iqbalmadiqbalmad Member Posts: 179
edited 2006-12-13 in Navision Attain
hi all,

is there a quick way to find the LATEST date in a range of records??

thanks

Comments

  • krikikriki Member, Moderator Posts: 9,112
    Well, if you have an index on date, it is easy.

    Otherwise you have to loop the records to find it.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • WaldoWaldo Member Posts: 3,412
    If you have the index, this is some pseudocode:
    myrec.SETCURRENTKEY(Datafield);
    IF myrec.FIND('+') THEN
      LatestDate := myrec.Datefield;
    

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.