ampm

Type
Time Function

Purpose
The ampm function evaluates a value expressed in the 24-hour time format (HH:MM:SS) and returns the appropriate abbreviation AM (before noon), or PM (after noon).

Syntax
ampm( TIME VALUE)

Returns:
A text value (either AM or PM).

Usage:
Time values from midnight (00:00:00) to (11:59:59) return AM. Time values from noon (12:00:00) to (23:59:59) return PM.

Examples:
ampm( 08: 15: 25)
Returns: AM
ampm( 15: 30: 50)
Returns: PM