StrToMember -
09-20-2004
, 05:05 AM
Hello,
I am having problem with the STRTMEMBER functions.
What in need :
([Measures].[Qte Stock], [Date Année Mois].[Année].&[2004].&[6])
, but for current Year and month.
The above formula works, but I cannot get it working with the combination
of Strtomember and the Now() VB;
This should look to something like :
([Measures].[Qte Stock], StrToMember("[Date Année Mois].[Année].&
["+LTRIM(str(YEAR(now())))+"].&["+LTRIM(str(MONTH(now())))+"]"))
the syntax is OK, but I received errors while executing it.
Any help would be appreciated. |