I need to combine two columns to print as one in the FEX file. I have a view with the century (19,20) in one column and the tax year (99,01) in another column and I need them to print together as 1999 or 2001.

EXAMPLE

TABLE FILE "view name"

PRINT

taxpayer_name AS 'name'
taxpayer_number AS 'number'
century + year AS 'tax year' -- I need the correct wording for this one???

This message has been edited. Last edited by: Julie H.,

You need to COMPUTE that...

if it's alphanumeric

COMPUTE RTFM/A4 = century | year; AS 'Tax year';

Or if it's numeric

COMPUTE RTFM/D4 = ( century * 100 ) + year; AS 'Tax year';

Oh... and please... do some course or reading. This is VERY basic stuff. It's even in the 'help' of the developer studio.


Greets,Dave

( please complete your signature )