DATE ()
DATE(date, [format])Extracts and formats the date part of a string representing a date (which can contain also the time part)
The parameter FORMAT allows to specify formatting options for the value returned
Input Parameters
Parameter | Type | Default | Required | Description |
|---|---|---|---|---|
|
| Yes |
| |
| Y-M-D | No | The desired format of the date returned can include the following constants:
The FORMAT parameter can contain other texts apart from the predefined constants.For example (“Date is d/m/Y”) |
Execution
Always. Calculated on-the-fly whenever an ITEM of a FORM is changed (by means of form_set_answer(), or when the FORM is opened
Examples
Formula | Description |
|---|---|
| Returns “01/09/2021” |
| Returns “1-9-21” |
| Returns “Year: 2021” |