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