OLTimeStamp ( FMDate ; FMTime )

Creates an Outlook Compatible Start/End time value.

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

Hartger Visser
Teuker Beheer BV
http://www.teuker.nl

Sample input:

OLTimeStamp ("16/3/05" ; "13:30" )

Sample output:

3/16/2005 1:30:00 PM

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

/*---------------------------------------------------------------
Function Name: OLTimeStamp

Syntax: OLTimeStamp ( FMDate; FMTime )

Author - Hartger Visser
http://www.teuker.nl
---------------------------------------------------------------*/


Let ( 
 [ 


time = GetAsTime ( FMTime ) ; 
hours = Hour ( time ) ; 
calcHours = Case( 
( FMTime < GetAsTime ( "01:00" ) ) or ( hours - 12 = 0 ) ; 12 ;
                             hours ≥ 12; hours - 12 ; 
                             hours
                            ) ; 
calcMinutes = Left ( "00" ; 2 - Length ( Minute ( time ) ) ) & Minute ( time ) ; 
calcSuffix = If ( hours ≥ 12 ; "PM" ; "AM" )
 ] ; 

Month( FMDate ) & "/" & Day ( FMDate )  & "/"  & Year ( FMDate )  & " " & 
calcHours & ":" & calcMinutes & ":00 " & calcSuffix
)

Converts a Filemaker date and time to a String that can be used 'manipulating' MS Outlook data. Outlook requires this 'international' format to receive a Start of End time in appointments and calendar fields.

Comments

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

OLTimeStamp ( FMDate ; FMTime )

Comments

Support this website.

Support this website.