Brian Dunning's FileMaker Custom Functions

DateArrayCurrent ( array ; i )

Outputs current or greater dates from an Array.

  Average rating: 4.5 (22 votes) Log in to vote

Casey Dutkus   Casey Dutkus
http://www.accasey.com

Share on Facebook Share on Twitter

  Sample input:
DateArrayCurrent (
01/01/1966
01/01/2099 , 1 )
  Sample output:
01/01/2099

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Drops dates that are not current. It's simple, but effective.

If you wanted to add a variable so that you can difine current date within script do this:

DateArrayCurrent(array; dateCurrent; i)

change:

current = Get ( CurrentDate) to
current = dateCurrent

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.