Month (Expression Function)

Purpose

The Month function (MONTH) generates a number that represents the month for a timestamp provided in a given timezone.

Parameters

The Month 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 Month 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 Month function is number representing the month for the value of the timestamp provided in a given timezone.

Example

For example MONTH(1349047828,“America/New_York”) would result in “9” and MONTH(1349047828,“Asia/Tokyo”) would result in “10”.

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