CurrentRecurrence ( FirstRecurrenceDate, CurrentDateStart, CurrentDateEnd, Frequency )

Takes a start date, and finds the first recurrence within a date range (given a frequency)

Average rating: 4.0 (2 votes) Log in to vote

Kris Weyling - Show more from this author
Digital Fusion Ltd.
http://teamdf.com

Sample input:

CurrentRecurrence (
Date ( 1 ; 2 ; 2016 ) ;
Date ( 6 ; 4 ; 2017 ) ;
Date ( 6 ; 12 ; 2017 ) ;
"Weekly"
)

Sample output:

10/06/2017

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

/* 
CurrentRecurrence ( FirstRecurrenceDate, CurrentDateStart, CurrentDateEnd, Frequency )

Takes a start date, and finds the last recurrence within a date range (given a frequency)
Written by Kris Weyling 2017
*/

Let ([

	d_rec = FirstRecurrenceDate ;
	d_start = CurrentDateStart ;
	d_end = CurrentDateEnd ;
	fq = Frequency ;
	
	
	d_next = Case (

		fq = "Weekly" ; 
		GetAsDate ( d_rec ) + 7 ;
		
		fq = "Fortnightly" ; 
		GetAsDate ( d_rec ) + 14 ;

		fq = "Monthly" ; 
		Date ( 
			Month ( d_rec ) + 1 ;
			Day ( d_rec ) ;
			Year (d_rec )
		)



	)] ;

	Case (
	
		d_next ≤ d_end ;
		CurrentRecurrence ( d_next ; d_start ; d_end ; fq ) ;
		
		Case (
			( d_rec ≤ d_end ) and ( d_rec ≥ d_start ) ;
			d_rec
		)
	)
	
)

This function takes a recurrence start date and frequency. Using these it finds the first date the recurrence falls within a date range.

Comments

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

CurrentRecurrence ( FirstRecurrenceDate, CurrentDateStart, CurrentDateEnd, Frequency )

Comments

Support this website.

Support this website.