Use the formula in update rule

[Former Member]

Hi,

I need to load data from text data source that have 2 fields for representing month and year with the format as Jan,2007 Feb,2007 Mar,2006..... I need to transform them to 200701, 200702, 200603 for load them into 0CALMONTH, right?

Can the formula support this transformation? and How?

I tired to use IF( , ,IF ( , , IF( ))) ,but it doesn't allow to do like that.

Please suggest.

And for the future , where can I download the document for the formula using?

Thanks in advance.

Chet

[Former Member]

Is month and year - Calender Year & Calmonth2 ?

Formula may not work here.

If they are all Cals try mapping two ( Year and Month ) to one ( 0CALMONTH ) - Jst map both to Calmonth in Transformation.

Mapping surely works for say Fiscal Period from Fiscal Year and Posting Period.