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

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.

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


  2. Define the date function:

    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

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

See Drill Down Hierarchies for more information.

 

 

 

  • No labels