QtrRoundTS ( fmTimestamp )
Rounds a timestamp by quarter hour.
Average rating: 4.2 (34 votes) Log in to vote
Brian E Sanchez
Avant Garde Information Solutions, LLC.
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.
Dec 17, 2009
How about just:
Round ( timestamp / 900 ; 0 ) * 900
Jun 27, 2016
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.