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.