Brian Dunning's FileMaker Custom Functions

QtrRoundTS ( fmTimestamp )

Rounds a timestamp by quarter hour.

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

Brian E Sanchez   Brian E Sanchez
Avant Garde Information Solutions, LLC.
http://www.agisllc.com

Share on Facebook Share on Twitter

  Sample input:
12/25/2009 4:27:19 PM
  Sample output:
12/25/2009 4:30 PM

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

Rounds a timestamp by quarter hour, by calculating the offset of the timestamp's numeric equivalent, instead of toying with dates/times, AM/PM, this/next year, etc.

 

Comments

comment   comment, VR
Dec 17, 2009
How about just:

Round ( timestamp / 900 ; 0 ) * 900
 
Omelyan Burtnyk   Omelyan Burtnyk
Jun 27, 2016
Thank you!
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.