Convertion calendar week YYYYWW to month MM ->formular editor

[Former Member]

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

Abdel

[Former Member]

Hi all,

I have solved the problem as I converted the week to 0CALDAY at first by WEEK_TO_1ST_DAY(CALWEEK) and then in the next DTP from 0CALDAY to 0CALMONTH.

I have a new PROBLEM, that my formula causes problems in the transfer process as I had to make changes in the transformation rules and in the Flatfile-DataSource such as EAN-number instead of 0MATERIAL.

Does anybody knows why the fomula causes problems????? I didn't change anything, just inserted 0EANUPC (EAN-Number) instead of the characteristic 0MATERIAL!!!!!!!!!

Many thanks in advance to all!!!!!!!

Regards

Abdel

Edited by: Abdel on Aug 1, 2008 11:29 AM