UpcomingDate ( listOfDates )

Returns the earliest future date in listOfDates.

Average rating: 4.4 (46 votes) Log in to vote

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

UpcomingDate ( List ( Milestones::Date ) )

where Milestones are:
3/3/2011
1/1/2011
2/2/2011
4/4/2011

and today is Jan. 17 2011

Sample output:

2/2/2011

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

/*
UpcomingDate function

Author
*COMMENT Visual Realisation

Format
UpcomingDate ( listOfDates )

Parameters
listOfDates - a return-separated list of dates (in any order)

Data type returned
date

Description
Returns the earliest future date in listOfDates..

January 17, 2011
*/

Let ( [ 
today = Get (CurrentDate) ;
d1 = GetAsDate ( GetValue ( listOfDates ; 1 ) ) ;
d2 = GetAsDate ( GetValue ( listOfDates ; 2 ) ) ; 

d = Case (
today < Min ( d1 ; d2 )  ; Min ( d1 ; d2 ) ;
today < Max ( d1 ; d2 )  ; Max ( d1 ; d2 ) ;
) ;

countDates = ValueCount ( listOfDates ) 
] ; 
Case ( 
countDates > 2 ; 
UpcomingDate ( RightValues ( listOfDates ; countDates - 2 ) & d ) ;
d
)
)

Returns the earliest future date in listOfDates. The dates in listOfDates can appear in any order.

Comments

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

UpcomingDate ( listOfDates )

Comments

Support this website.

Support this website.