DateQuarterEnd ( theDate )

Pass any date and get the quarter END date based on input date.

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

Chiyoko Yoshida
chiyofm
http://www.chiyofm.com/

Sample input:

DateQuarterEnd ( 7/15/2010 )

Sample output:

9/30/2010

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

//NAME: DateQuarterEnd
//PURPOSE: Pass any date and return the quarter END date based on the input date.
//PARAMETER: theDate
//INCLUDES OTHER CUSTOM FUNCTIONS: No
//CREATED BY: Chiyoko Yoshida chiyofm@gmail.com
//EXAMPLE INPUT: 7/15/2010 
//EXPECTED OUTPUT: 9/30/2010

Let ([

$d = theDate;
$m = Month($d);
$y = Year($d)

];

If ( $m > 9 ; Date (12;31;$y);
If ( $m > 6 ; Date (9;30;$y);
If ($m > 3 ; Date (6;30;$y);
Date(3;31;$y)
)))

)

Out put the year quarter end date based on the date input to the function. Supply the get(currentdate) to get the current quarter end date.

Comments

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

DateQuarterEnd ( theDate )

Comments

Support this website.

Support this website.