Year 4 Digit (Expression Function)

Purpose

The Year 4 Digit function (YEAR_4_DIGIT) generates a number that represents the year in 4 digit format for a timestamp provided in a given timezone.

Parameters

The Year 4 Digit 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 Year 4 Digit 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 Year 4 Digit function is number representing the Year in 4 digit format for the value of the timestamp provided in a given timezone.

Example

For example YEAR_4_DIGIT(1357009728,“America/New_York”) would result in “2012” and YEAR_4_DIGIT(1357009728,“Asia/Tokyo”) would result in “2013”.

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