Page Comparison

{anchor:top}
h2. Overview 
{styleclass: Class=topLink}[top|#top]{styleclass}
These templates 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.
# Select the date format you want in your hierarchy and drag the field into an appropriate category.
!115.png|thumbnail,border=1!
# Set up the meta data as normal
# In the bottom of the tab, select the field parameter you want to base your field on. Some of the formats require a timestamp as input, so the list you can choose from will differ depending on the format.
# Format your field as normal and save.

h2. Possible Fields (based on an SQL Server source connection)
{styleclass: Class=topLink}[top|#top]{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|
|Year Start Date|Date|Date or Date + Time|
|Year End Date|Date|Date or Date + Time|

bq. See [Drill Down Hierarchiesドリルダウン階層] for more information.
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}