Todate

Converts date strings to numbers that can be used in calculations.

Syntax

Todate ( character_string_literal_1 ,character_string_literal_2 )

character_string_literal_1 The format of the date string, either "mm-dd-yyyy" or "dd-mm-yyyy" (must be in lower case).
character_string_literal_2 The date string.

Example

For products introduced before 06.01.1996, the following query calculates a Revised Budget that is 110% of Budget.

WITH MEMBER
 [Scenario].[Revised Budget]
AS
 'IIF (
       [Product].CurrentMember.[Intro Date] 
        > TODATE("mm-dd-yyyy","06-01-1996"),
        Budget * 1.1, Budget
      )'
SELECT
 {[Scenario].Budget, [Scenario].[Revised Budget]}
ON COLUMNS,
 [Product].[200].Children 
 DIMENSION PROPERTIES [Intro Date]
ON ROWS
FROM Sample.Basic
WHERE ([Measures].[Sales], [Year].[Qtr3])

This query returns the grid:

Budget Revised Budget
200-10 11060 11060
200-20 9680 10648
200-30 3880 4268
200-40 2660 2926

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com