====== Day of the Month with Leading Zero (Expression Function) ======

+

===== Purpose =====

+

The **Day of the Month with Leading Zero** function (DAY_OF_THE_MONTH_WITH_LEADING_ZERO) generates a number that represents the day of the month for a timestamp provided in a given timezone. ​

+

+

{{:​day_on_month_with_leading_zero_initial.png?​direct&​600|}}

+

+

===== Parameters =====

+

The **Day of the Month with Leading Zero** 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 **Day of the Month with Leading Zero** 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 **Day of the Month with Leading Zero** function is string representing the day of the month with leading zero for the value of the timestamp provided in a given timezone.

+

+

===== Example =====

+

+

For example DAY_OF_THE_MONTH_WITH_LEADING_ZERO(1349212984,"​America/​New_York"​) would result in "​02"​ and DAY_OF_THE_MONTH_WITH_LEADING_ZERO(1349212984,"​Asia/​Tokyo"​) would result in "​03"​.

expression function - day of the month with leading zero.txt · Last modified: 2016/09/14 14:19 (external edit)