TimeStamptoString ( Time_Stamp )

Take a time stamp and converts it to simple sting with 24 hr time

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

Andrew Greaves
UCSD Cancer Center
http://www.cllresearch.org

Sample input:

TimeStamptoString ( Time_Stamp )

9/17/2004 12:53:34 PM

Sample output:

09172004245334

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

Let  ( [ 
Date1 = LeftWords ( GetAsText (Time_Stamp);1);
month1 = Month ( Date1);
day1 = Day( Date1);
year1 = Year (Date1);
Time1 = MiddleWords ( GetAsText (Time_Stamp)  ; 2 ; 1 );
AMPM = RightWords ( Time_Stamp;1 );

hours1 = If (AMPM = "PM" ; Hour (Time1) +12 ; Hour (Time1));
minutes1 = Minute (Time1);
seconds1 = Seconds ( Time1 ) ] ;

If ( Length (month1) = 1 ; "0" & month1 ; month1) &
If ( Length (day1) = 1 ;   "0" &  day1  ; day1 ) & 
year1 &
 
If (Length (hours1 ) = 1 ; "0" & hours1; hours1) &
If (Length (minutes1) = 1 ; "0" & minutes1 ; minutes1) &

If (Length (seconds1) = 1; "0" & seconds1 ; seconds1) )

This converts the FMP timestamp to a numeric 24 hour string. this could be reused for any number of other possibilities.

Comments

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

TimeStamptoString ( Time_Stamp )

Comments

Support this website.

Support this website.