Converts date strings to numbers that can be used in calculations.
Syntax
Todate ( string_value_expression_1 ,string_value_expression_2 )
| Parameter | Description |
|---|---|
string_value_expression_1 | The format of the date string, either "mm-dd-yyyy" or "dd-mm-yyyy" (must be in lower case). |
string_value_expression_2 | The date string. |
Notes
If you specify a date that is earlier than 01-01-1970, this function returns an error.
The latest date supported by this function is 12-31-2037.
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:
| Axis-1 | Axis-1.properties | Budget | Revised Budget |
|---|---|---|---|
| 200-10 | (Intro Date = 09-27-1995, type: TIME, ) | 11060 | 11060 |
| 200-20 | (Intro Date = 07-26-1996, type: TIME, ) | 9680 | 10648 |
| 200-30 | (Intro Date = 12-10-1996, type: TIME, ) | 3880 | 4268 |
| 200-40 | (Intro Date = 12-10-1996, type: TIME, ) | 2660 | 2926 |