Extracted Data
1. Overview
Syntax | QUARTER(Serial_number,Format) | Returns the quarter in the date. If no parameter is required, the function returns the quarter of the current server time. |
Parameter 1 | Serial_number | The parameter can be empty and of any type. |
Parameter 2 | Format | The parameter can be empty and should be of the text type. |
Returned value | Number | Returns a number. |
2. Example
Formula | Result | Note |
QUARTER() | The quarter of the current server time | |
QUARTER("2017-03-07 00:00:00") | 1 | |
QUARTER("2017/03/07") | 1 |
Real-Time Data
1. Overview
Syntax | QUARTER(Serial_number) | Returns the quarter in the date. If no parameter is required, the function returns the quarter of the current server time. |
Parameter 1 | Serial_number | The parameter can be empty and be of the date or text type. |
Returned value | Number | Returns a number. |
2. Example
Formula | Result | Note |
QUARTER() | The quarter of the current server time | |
QUARTER("2017-03-07 00:00:00") | 1 | |
QUARTER("2017/03/07") | 1 |
