MONTH Function
Function Type | Predefined function | |
Syntax | MONTH( <dateValue> ) | |
Description | Returns an integer between 1 and 12, inclusive, that represents the month of the year for a date argument. | |
Argument | Description | |
<dateValue> | Any Date or Timestamp data type. If <dateValue> is Null, this function returns Null. | |
Returns | Integer | |
Example | This example examines the data in the source field, ShipDate, that contains a valid date and returns a two-digit month designation. MONTH(Source.Table.ShipDate) | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*