DateArrayCurrent ( array ; i )

Outputs current or greater dates from an Array.

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

Casey Dutkus - Show more from this author
http://www.accasey.com

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)

//DateArrayCurrent(array;i)
//By Casey Dutkus

Case(IsEmpty(array); "";
Let(
[ 
  x = GetAsDate( GetValue(array; i) );
  current = Get ( CurrentDate ) //Defines Current Date
];
Case(
         x ≥ current; x & "¶";
         x < current; ""
        )
& Case( ValueCount(array) > i ; DateArrayCurrent( array; i + 1) ) 

) //End Let
) //End Case

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

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

DateArrayCurrent ( array ; i )

Comments

Support this website.

Support this website.