Hi everybody,
I have a strange problem with date ranges. I am using MDX Sample
Application. First code below works fine. Second code returns the error
message "Unable to open cellset. The operation has failed because of an
error in the COM component - unknown error"

Both dimensions (Date & Date Placed) have the same structure. Example:
- 2004 (Year)
- Quarter 1, 2004 (Quarter)
- January, 2004 (Month)
- January 5, 2004 (Day)

What's wrong?

Thanks in advance for your help.

Regards,
Marco


Code 1
------
WITH
SET [SetRange] as 'FILTER ([Date].[Day].Members,
VBA!CDate([Date].CurrentMember.Name) <= VBA!CDate("01/04/2004") )'
MEMBER [Date].[Range] As 'Aggregate([SetRange])'
SELECT
{Measures.DefaultMember} on columns,
NON EMPTY {[Plant].Children} on rows
FROM [Sales]
WHERE ([Date].[Range])

Code 2
------
WITH
SET [SetRange] AS 'FILTER( [Date Placed].[Day].Members, VBA!CDate([Date
Placed].CurrentMember.Name) <= VBA!CDate("03/27/2004") )'
MEMBER [Date Placed].[Range] AS 'Aggregate([SetRange])'
SELECT
{Measures.DefaultMember} on columns,
NON EMPTY {[Plant].Children} on rows
FROM [CIR]
WHERE ([Date Placed].[Range])