Hi

I am trying to filter out records which have a member property of
greater than a certain date.
EG Member property of Date Created and I want to see all members
created after a certain date. How would this work in MDX?

I have tried the following

SELECT { [Time].DEFAULTMEMBER } ON COLUMNS ,
{Filter([BOM Production].[Prod No].Members, VAL
([BOM Production].CurrentMember.Properties("Created Date")) >
01/01/2000 )} ON ROWS
FROM [Production]
WHERE ( [Measures].[Production Qty Started] )

If I remove the VAL part of this I get a "token not valid" error when
parsing the query. The property Created Date field is a proper DateTime
field. I need to know what would work with this. I have tried
substituting VAL with DATE, TIME and also removing the VAL altogether.
None of this has worked.

Maybe try using CDATE() instead of VAL()

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1148390981.286616.24010 (AT) 38g2000cwa (DOT) googlegroups.com>,
alanmidwinter (AT) hotmail (DOT) com says...

Thought you should know that the solution was as follows

SELECT{ [Time].DEFAULTMEMBER, [Time].[Created Date] } ON COLUMNS ,
{Filter([BOM Production].[Prod No].Members, CDATE
([BOM Production].CurrentMember.Properties("Created Date")) >
datevalue("01/01/2003") )} ON ROWS

FROM [Production]

I was not using the datevalue function for converting the tring I typed.