I Just cannot find the correct answer for what seems the most simple thing

I am Creating a KPI in Dashboard Designer the KPI is for Total Quotes for the Current Month, I can create the query but i would have to change it every month which i dont want to do so i need it to be Dynamic.

I have a time dimension which is as follows

[Time].[Year - Month - Date]

I have tried the following

([Measures].[Total Quotes], StrToMember("[Time].[Year - Month - Date].[Month].&["+CStr(Format(Now(),"yyyy-MM-dd"))+"T00:00:00]"))

but it just returns a value of null

somebody must know how to do this

John