Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Styleclass
ClasstopLink

top

These templates 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.

  1. Select the date format you want in your hierarchy and drag the field into an appropriate category.
    Image Removed
  2. Set up the meta data as normal
  3. 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.
  4. Format your field as normal and save.

 

Wiki Markup
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/kvU_pe7Yzqo?color=white" frameborder="0" allowfullscreen></iframe>{html}
 

...

  1. Click on the Create button and select the Date Function option.
    Image Added

  2. Define the date function:
    Image Added
    1. Select a field to base the function on.
    2. Select which function to apply to the data.
    3. Select the format to display the data in after the conversion.
    4. Select a field folder to place the converted date field.

  3. Click Save.

 

Possible Fields

Styleclass
ClasstopLink

top

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 DateDateDate or Date + Time
Quarter End DateDateDate or Date + Time

Year Start Date

Date

Date or Date + Time

Year End Date

Date

Date or Date + Time

...