- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
expression function - ampm uppercase [2016/09/14 18:19] |
expression function - ampm uppercase [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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. | ||
+ | |||
+ | {{:am_pm_uppercase_initial.png?direct&600|}} | ||
+ | |||
+ | ===== Parameters ===== | ||
+ | The **AMPM Uppercase** function has two parameters, one of which is required: | ||
+ | |||
+ | ==== Timestamp ==== | ||
+ | |||
+ | Allowed Inputs: [[Field|field]] value or a number representing a Unix timestamp. | ||
+ | |||
+ | There are several sources of Unix timestamps available. For example the stored value of a [[Field Type - Date|date]] or [[Field Type - Date Time| date time]] field is a Unix timestamp. Also When using the advanced interface the output of the [[Expression Function - Date|date]] or [[Expression Function - Date and Time| date time]] expression function is a Unix timestamp. | ||
+ | |||
+ | ==== Timezone ==== | ||
+ | |||
+ | Allowed Inputs: [[Field|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". |