====== Day of the Month (Expression Function) ======

===== Purpose =====
The **Day of the Month** function (DAY_OF_THE_MONTH) generates a number that represents the day of the month for a timestamp provided in a given timezone. 

{{:day_on_month_initial.png?direct&600|}}

===== Parameters =====
The **Day of the Month** 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** 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** function is string representing the day of the month for the value of the timestamp provided in a given timezone.
===== Example =====

For example DAY_OF_THE_MONTH(1349212984,"America/New_York") would result in "2" and DAY_OF_THE_MONTH(1349212984,"Asia/Tokyo") would result in "3".