Script help: Find today's or the next date in the field
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.
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,