AMPM Uppercase (Expression Function)

Purpose

The AMPM Uppercase function (AMPM_UPPERCASE) generates a string that represents “ante meridiem” or “post meridiem” value of the timestamp provided for a given timezone.

Parameters

The AMPM Uppercase function has two parameters, one of which is required:

Timestamp

Allowed Inputs: field value or a number representing a Unix timestamp.

There are several sources of Unix timestamps available. For example the stored value of a date or date time field is a Unix timestamp. Also When using the advanced interface the output of the date or date time expression function is a Unix timestamp.

Timezone

Allowed Inputs: field value or a text string

The second optional parameter of the AMPM Uppercase function is a string that represents the timezone. Either use the query builder to choose a field that contains the value or use type a value to enter a number. The value should be based on the tz (timezone) database used by Linux and other Unix system in the form “Area/Location” e.g. “America/New_York”. If no value is provided then the current user's timezone is used.

Output

The output of the AMPM Uppercase function is string representing “ante meridiem” or “post meridiem” value of the timestamp provided for a given timezone all in upper case.

Example

For example AMPM_UPPERCASE(1349212984,“America/New_York”) would result in “PM” and AMPM_UPPERCASE(1349212984,“Asia/Tokyo”) would result in “AM”.

expression function - ampm uppercase.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2018