TimeFormat ( InTime ; InFormat )

Returns text version of time, InTime, in specified format, InFormat.

Be the first to rate this function Log in to vote

Richard DeShong - Show more from this author
Logic Tools
http://logictools.com

Sample input:

TimeFormat( 1:25 PM ; "hh:mm:ss" )

Sample output:

"13:25:00"

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

Let([
   h = Hour( InTime ) ;
   m = Right( "00" & Minute( InTime ) ; 2 ) ;
   s = Right( "00" & Seconds( InTime ) ; 2 ) ;
   ap = Case( h >= 12 ; "PM" ; "AM" ) ;
   h12 = h - Case( h >=24 ; 0 ; h > 12 ; 12 ; 0 )
];
   Case(
      InTime = "Empty"  or  IsEmpty( InTime ) ; "null" ;
      InFormat = "hh:mm:ss" ; right( "00" & h ; 2 ) & ":" & m & ":" & s ;
      InFormat = "hh:mm AMPM" ; right( "00" & h12 ; 2 ) & ":" & m & " " & ap ;
      right( "00" & h12 ; 2 ) & ":" & m & lower( left( ap ; 1 ) )
   )
)
/*
  Returns text version of time.  If no time, returns "null".
  ( 13:25:00 ; "hh:mm:ss" )	returns:  13:25:00
  ( 13:25:00 ; "hh:mm AMPM" )	returns:  1:25 PM
  ( 13:25:00 )			returns:  1:25p
*/

Given a time value, returns a text version of time in a specified format.
FM's time fields show the time in the format the user entered it;
This function makes sure that times are all displayed the same way.
Currently three formats are coded (include a default minimum style format):
TimeFormat( 13:25:00 ; "hh:mm:ss" ) returns: "13:25:00"
TimeFormat( 13:25:00 ; "hh:mm AMPM" ) returns: "1:25 PM"
TimeFormat( 13:25:00 ) returns: "1:25p"

Comments

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

TimeFormat ( InTime ; InFormat )

Comments

Support this website.

Support this website.