Sorry folks, but this is a repost... I am getting desperate here.

I need to filter transactions that occured after the last date of a
particular type of transaction.

When I hardcode the date, it works fine. When I use a date value that is in
the cube it either gives err when I convert it with cdate, or gives a
bizzare answer when I leave it out.

Does anyone have an example of how to filter on date???

I have found many instances of this question by Googling, but no good
answers that help me.

********************************

This works

sum(
filter(
crossjoin(
{[time].[day].members},
{[account].[capital call]}
),
[measures].effectivedate > cdate("3/31/2003")), USDAmount)

******** But this does not

HOWEVER when I want to the effective date of the last Market Value it shows
no error in the calculated member builder by it returns ERR

sum(
filter(
crossjoin(
{[time].[day].members},
{[account].[capital call]}
),
[measures].effectivedate > cdate(([Account].[Last Market Value],
[Measures].[Effectivedate]))), USDAmount)



If I leave the "cdate" out, I get an answer back, but its not at all what I
would expect.