I am trying to convert the value convert 140119 TO 2014/01/19, but I keep getting 1914/01/19. I am doing this in a synonym. How do I get the century to change? the formats I am using I6YMD to I8YYMD.

This message has been edited. Last edited by: Jay Potter,

How are you currently doing it in the synonym?

Add SET DEFCENT = 20 to edasprof.prf if you're working with dates that do not contain the century.

SET DEFCENT = 20

TABLE FILE CAR
PRINT
COMPUTE DT1/YMD = '140119';

COMPUTE DT1_YYMD/YYMD = DT1;

BY COUNTRY NOPRINT
WHERE READLIMIT EQ 1;
END

Here is my synonym code.

DEFINE IB_A099PTDT_I6YMD/I6YMD=A099PTDT; $
DEFINE IB_A099PTDT_YYMD/YYMD=IB_A099PTDT_I6YMD; $

Look up DEFCENT and YRTHRESH in the Developing Reporting Applications manual, Customizing Your Environment section.

I updated edaprof and it worked.

Thanks

As Francis says, check the documentation on DEFCENT and YRTHRESH, so you understand how the windowing for two digit year dates works.