Skip to Content
Former Member
Jul 17, 2008 at 04:01 PM

Convertion calendar week YYYYWW to month MM ->formular editor


Hi all,

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!

Best Regards