TimeAsText ( theTime )
Converts time to a text format using a 12-hour clock.
Average rating: 4.5 (28 votes) Log in to vote
Howard Schlossberg - Show more from this author
FM Professional Solutions
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
When a time is combined into a calc with other text, the result needs to be text. As such, you cannot use FileMaker's built-in layout time formatting to properly format the time in a layout field object. The default is for FMP to show time in a 24-hour format. This function provides a simple means of always showing the time in a 12-hour format.
|Jon Davidson, Cazenovia, NY
Jan 13, 2013
|Thank you, thank you, thank you. I've been searching the Filemaker Tech site for an answer to show the time value in a Variable without showing seconds. I couldn't find an answer until I stumbled accross you custom function. It was perfect.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.