This function returns True if date lies inside the quarter containing basedate.
Syntax:
InQuarter (date, basedate , shift [, first_month_of_year = 1])
Arguments:
| Argument | Description |
|---|---|
| date | The date that you want to compare with basedate. |
| basedate | Date that is used to evaluate the quarter. |
| shift |
The quarter can be offset by shift. shift is an integer, where the value 0 indicates the quarter which contains basedate. Negative values in shift indicate preceding quarters and positive values indicate succeeding quarters. |
| first_month_of_year | If you want to work with (fiscal) years not starting in January, indicate a value between 2 and 12 in first_month_of_year. |