AnsweredAssumed Answered

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

Question asked by precociousninja on Jun 22, 2010
Latest reply on Jun 22, 2010 by philmodjunk

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

Outcomes