DateQuarterAsRange ( theDate )

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

Average rating: 4.2 (37 votes) Log in to vote

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

Sample input:

DateQuarterAsRange ( 7/15/2010)

Sample output:

7/1/2010...9/30/2010

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

//NAME: DateQuarterAsRange
//PURPOSE: Pass any date and return the current quarter Start and END date as FM find date range.
//PARAMETER: theDate
//INCLUDES OTHER CUSTOM FUNCTIONS: No
//AUTHOR: Chiyoko Yoshida chiyofm@gmail.com
//EXAMPLE INPUT: 7/15/2010 
//EXPECTED OUTPUT: 7/1/2010...9/30/2010

Let ([

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

$qStart = If ( $m > 9 ; Date (10;1;$y);
                 If ( $m > 6 ; Date (7;1;$y);
                 If ($m > 3 ; Date (4;1;$y);
                 Date(1;1;$y)
               )));

$qEnd = 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)
              )))

];

$qStart & "..." & $qEnd

)

Out put a filemaker style date range for the quarter of the year, based on the input date. Use get(currentdate) to get current quarter date range. Handy for searches etc...

Comments

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

DateQuarterAsRange ( theDate )

Comments

Support this website.

Support this website.