Page History
Anchor | ||||
---|---|---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
- 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
Styleclass | ||
---|---|---|
| ||
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.
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||