Discussion :

[clementratel]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
STRTOMEMBER(
"[dimensionTemps].[hierarchieTemps].[Year].&[" +
CStr(Year(NOW())) + "0101].&[" + CStr(YEAR(NOW())) +
IIF(MONTH(NOW())>=1 AND MONTH(NOW())<=3,"01",
       IIF(MONTH(NOW())>=4 AND MONTH(NOW())<=6,"04",
               IIF(MONTH(NOW())<=7 AND MONTH(NOW())<=9,"07",
                       IIF(MONTH(NOW())<=10 AND MONTH(NOW())<=12,"10",ProblemWithMonth)
       )
   )
) + "01].&["+ CStr(YEAR(NOW())) +
IIF(MONTH(NOW())<10,"0"+CStr(MONTH(NOW())),Cstr(MONTH(NOW()))) + "01]"
,CONSTRAINED)