Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

FiveRountTS ( mytimestamp )

Rounds timestamp to the nearest 5 minute mark

  Average rating: 4.3 (7 votes) Log in to vote

Jeff Morrison - Show more from this author

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

/* Receives a timestamp, then returns a timestamp rounded to the nearest 5 minute mark. For example: 1/1/2017 01:03:00 would return 1/1/2017 01:05:00, but 1/1/2017 01:02:00 would return 1/1/2017 01:00:00 Uses a single case statement. Since a case statement stops once it reaches a line that is true, we test at 3 minutes, then 8, etc. Less than 3 rounds to 0, less than 8 rounds to 5, less than 13 rounds to 10, etc. */ Case( Minute ( mytimestamp ) < 3; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "00" ; "00" ); Minute ( mytimestamp ) < 8; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "05" ; "00" ); Minute ( mytimestamp ) < 13; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "10" ; "00" ); Minute ( mytimestamp ) < 18; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "15" ; "00" ); Minute ( mytimestamp ) < 23; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "20" ; "00" ); Minute ( mytimestamp ) < 28; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "25" ; "00" ); Minute ( mytimestamp ) < 33; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "30" ; "00" ); Minute ( mytimestamp ) < 38; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "35" ; "00" ); Minute ( mytimestamp ) < 43; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "40" ; "00" ); Minute ( mytimestamp ) < 48; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "45" ; "00" ); Minute ( mytimestamp ) < 53; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "50" ; "00" ); Minute ( mytimestamp ) < 58; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & Time ( Hour ( mytimestamp ); "55" ; "00" ); Minute ( mytimestamp ) ≥ 58 and Hour ( mytimestamp ) = 23; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp )) + 1 & " " & "00:00:00" ; Date ( Month ( mytimestamp ) ; Day ( mytimestamp ) ; Year ( mytimestamp ) ) & " " & "12:00:00 AM" ) Click to copy

Ronds up or down to the nearest 5 minute mark based on the timestamp used.
Examples:
1/1/2017 01:03:00 returns 1/1/2017 01:05:00
1/1/2017 14:42:02 returns 1/1/2017 14:40:00
1/1/2017 23:58:20 returns 1/2/2017 00:00:00

 

Comments

		unix, Japan Jan 9, 2017
This returns timestamp as text. To get it, simply divide it with 300 (5min in seconds) then round. GetAsTimestamp ( Round ( mytimestamp / 300 ; 0 ) * 300 )

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: