4 Replies Latest reply on Jun 22, 2010 3:31 PM by philmodjunk

    Script help: Find today's or the next date in the field

    precociousninja

      Title

      Script help: Find today's or the next date in the field

      Post

      Hey all,

       

      I am running FMP 10 on Mac OS 10.5.8.

       

      I am trying to write a script that finds today's date in a date field, and if today's date doesn't exist, it finds the next date listed.

       

      For example: 

       

      If today is 6/22/2010 which doesn't exist in any record's date field.  The next date in that field is 6/29/2010.  When the find script is performed it automatically goes to the 6/29/2010 date. But, if the next date was 7/2/2010, it would know to go to that date instead.  

       

      I hope that makes sense.  

       

      Thanks for any help in advance,

       

      pn