I would appreciate it if somebody could help me to convert the calendar week YYYYWW to calendar month MM in the formular editor of the BI 7.0.
I have tried the following:
DATECONV( CALWEEK, 'YYYYMM', '' ) but it does not function.
I have also tried:
DATE_MONTH2( WEEK_TO_1ST_DAY( CALWEEK ) ) It also does not function. I always have problems in the DTP.
Many thanks in advance for your proposals!