The PERIOD function converts a date to a time period.
For example, you can use the PERIOD function to show which financial quarter a date falls under.
PERIOD(Date)
Arguments
| Argument | Data type | Description |
| Date | Date | The date to convert the time period from. |
The PERIOD function returns a time period.
Constraints
- Source must be date formatted.
- Result must be time period formatted.
- Result must fall within the time bounds of the model.
In Polaris, you can only use PERIOD in a line item that has a Type of Time Period. The result has the same timescale as the line item type.
Examples
In the example, the formula returns the month and quarter for the date 12/02/2015.
Period Month has the time period set to month, and Period Quarter has the time period set to quarter.
| Key Date | |
| Date | 12/02/2015 |
Period Month
| Feb 2015 |
Period Quarter
| Q1 FY15 |
