Overview
These functions allow you to convert dates and timestamps into various formats, which can then be used to build detailed date drill down hierarchies. The list of available formats will vary depending on source database type.- Click on the Create button and select the Date Function option.
- Define the date function:
- Select a field to base the function on.
- Select which function to apply to the data.
- Select the format to display the data in after the conversion.
- Select a field folder to place the converted date field.
- Click Save.
Possible Fields
The date functions available will depend on the type of database your view is based on. The list below is a sample only, and may not be applicable to your setup.Field | Output Type | Input |
|---|---|---|
Date | Date | Date or Date + Time |
Year | Integer | Date or Date + Time |
Month | Integer | Date or Date + Time |
Month Name | Varchar | Date or Date + Time |
Day of Month | Integer | Date or Date + Time |
Quarter | Integer | Date or Date + Time |
Week of Year | Integer | Date or Date + Time |
Day of Year | Integer | Date or Date + Time |
Day of Week | Integer | Date or Date + Time |
Day Name | Varchar | Date or Date + Time |
Hour | Integer | Time |
Minute | Integer | Time |
Second | Integer | Time |
Week Start Date | Date | Date or Date + Time |
Week End Date | Date | Date or Date + Time |
Month Start Date | Date | Date or Date + Time |
Month End Date | Date | Date or Date + Time |
| Quarter Start Date | Date | Date or Date + Time |
| Quarter End Date | Date | Date or Date + Time |
Year Start Date | Date | Date or Date + Time |
Year End Date | Date | Date or Date + Time |
See Drill Down Hierarchies for more information.