TimestampOffset ( Time_Stamp ; Weeks ; Days ; Hours ; Minutes ; Second ; Plus_Minus )

Allows Offset of a timestamp by multiple days or times

Average rating: 4.1 (20 votes) Log in to vote

Yvonne Dutreaux - Show more from this author
Cordblood Registry

Sample input:

TimestampOffset ( GetAsTimestamp ( "11/01/2015 12:00:00 PM" ) ; 1 ; 2 ; 3 ; 4 ; 5 ; "Plus")
TimestampOffset ( GetAsTimestamp ( "11/01/2015 12:00:00 PM" ) ; 1 ; 2 ; 3 ; 4 ; 5 ; "Minus")

Sample output:

11/10/2015 3:04:05 PM
10/23/2015 8:55:55 AM

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

Let ( 
[
W = Weeks * 7 ; 
D = ( Days + W ) * 24 ;
H = ( Hours + D ) * 60 ; 
M = ( Minutes + H ) * 60 ;
S = Second + M ;
O = Case ( Plus_Minus = "Minus" ; 0 - S ; S  )
]
; 
Time_Stamp + O

)

Allows a timestamp to be offset but any grouping of time units from weeks to seconds.

Comments

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

TimestampOffset ( Time_Stamp ; Weeks ; Days ; Hours ; Minutes ; Second ; Plus_Minus )

Comments

Support this website.

Support this website.