Formatting the time (show am/pm)

The FormatTime command takes the HH or hh parameters to display the time in 24 or 12 hour time respectively, but what if you want to show the time in 12 hour clock, and display AM or PM? Here’s how:

«FormatTime(AppointmentTime,'hh:mm tt')»

Add an additional ‘tt’ to show the AM or PM.

Here are the two formats of the same time:

«FormatTime(AppointmentTime,'hh:mm tt')» «Comment(12 hour clock with AM or PM)»

«FormatTime(AppointmentTime,'HH:mm')» «Comment(24 hour clock)»

 

Table of Contents