Hi ,

I stuck up in concatinating the year and the month fields.
I do have a filed contains the year and an another field with month.

I need to concatenate it in to a single filed.
Please do let me know your suggestions.



Thanks

This message has been edited. Last edited by: Kerry,

What are the format of the two fields?

are this numeric fields?

what did you try

Year field format is yy and month field format is mm.

Thanks

You may wish to consider the use of DEFINE; follow the link in the upper right corner for TechDoc. Or use the help feature in WebFOCUS. Look for 'concatentae' or 'concatentation.'

so both fields are smartdate fields?

if so did you try just this

NEWDATE/YYM=YEARDATE;

quote:

Year field format is yy and month field format is mm.

What is the WebFOCUS format? "mm" is not a valid format.

Hi Francis,

Here is the code that I tried.
I got the year and month.
I am trying to concatenate YEAR and MONTH fields.


-MRNOEDIT BEGIN
TABLE FILE EMPLOYEE
PRINT
HIRE_DATE
-*COMPUTE DATE1/YYMD=HIRE_DATE; NOPRINT
-*COMPUTE DATE_FINAL/YYMD=DATEADD(DATE1,'M',-3);
COMPUTE YEAR/YY=HIRE_DATE;
COMPUTE MONTH/M=HIRE_DATE;
-*COMPUTE YEARMONTH/YYM=YEAR|'/'|MONTH;
END
-MRNOEDIT END


Thanks
Ani

The statement, COMPUTE YEARMONTH/YYM=YEAR|'/'|MONTH, tells WebFOCUS that the variable is a so-called Smart date. It would appear that you want a character string like the following:
YEARMONTH/A7 = YEAR | '/' | MONTH;
Note the difference in format.

WebFOCUS 101:

  
TABLE FILE EMPLOYEE
PRINT
HIRE_DATE
-*COMPUTE DATE1/YYMD=HIRE_DATE; NOPRINT
-*COMPUTE DATE_FINAL/YYMD=DATEADD(DATE1,'M',-3);
COMPUTE YEAR/YY=HIRE_DATE; 
COMPUTE YEAR1/A4YY = EDIT(YEAR);
COMPUTE MONTH/M=HIRE_DATE; 
COMPUTE MONTH1/A2 = EDIT(MONTH);
COMPUTE YEARMONTH/A7=YEAR1 |'/'| MONTH1;
END

or even simpler still (forget about concatenating - just use the date):

TABLE FILE EMPLOYEE
PRINT
HIRE_DATE
COMPUTE NDATE1/YYM=HIRE_DATE;
COMPUTE NDATE2/A6YYM=NDATE1;
COMPUTE NDATE3/A7=EDIT(NDATE2,'9999/99');
END

Hi Darin,

It worked out thanks.


Thanks & Regards
Ani