QuarterOffset ( yearQuarter ; offset )

Returns a year-quarter string plus or minus a specified number of quarters

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

Joris Aarts
ClickWorks
http://www.clickworks.be

Sample input:

QuarterOffset ( "2007Q4" , -9 )

Sample output:

2005Q3

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

//Joris Aarts, ClickWorks
//Version 1.0  26/03/2008
//Example: YearQuarter = 2007Q4, Offset=-9, Result: YearQuarter = 2005Q3
Let([
       theYear = Left( YearQuarter ; 4 );
       theQ = Right( YearQuarter ; 1 );
       temp1Q = theQ + Offset;
       temp2Q = Mod( ( temp1Q ) ; 4 );
       newQ = If( temp2Q = 0 ; 4 ; temp2Q );
       tempYear = Floor( temp1Q / 4 );
       newYear = If( temp2Q =0; theYear + tempYear -1 ; theYear + tempYear ) 
];
newYear & "Q" & newQ
)//End Let

Returns a year-quarter string plus or minus a specified number of quarters.

Comments

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

QuarterOffset ( yearQuarter ; offset )

Comments

Support this website.

Support this website.