Also
SET CENTURY ON
SET CENTURY TO 19 ROLLOVER 20
? CTOD("01/01/50") && 01/01/1950
? CTOD("01/01/10") && 01/01/2010
This was introduce for the Y2K issue. Every think before today is in this century, and every thing after today date is considered last century.
>The Patient.ptDOB below is a 2-digit date. What is the simplest way to convert it to a 4-digit year date in a SQL statement? Thanks!
>
>
>PADR(THIS.Strip(TRANSFORM(Patient.PtDOB, '@T')), 30, ' ') AS PID_07_00_DateOfBirth, ;
>
Greg Reichert