>You are the man Sergey. Just a quick question... I have century set off, but yet it continues to show 2004. How can I make it just 04?
The TTOC(,1) function returns character representaion of the datetime suitable for an index key. It's independent of any date/time settings.
? SUBSTR(TRANSFORM(TTOC(DATETIME(),1), "@R 99999999_99_99_99"),3)
--sb--