Julian Date Convert

[shrey3a]

Hi,

I've date coming from DB2-AS400 as Julian . I'm able to succefully convert dates with using Functions

Ans=Oconv(Iconv(TheDate, "DYJ"), "D-YMD[4,2,2]")

Input - 90313
output - 1990-11-09

But I've dates coming in format for example :104314 i.e. 2004-11-09 for which above routine do not works. To make it simple where the i/p julian format is of 5 lenght the routine works but when it the source come as 6 length it fails ot I'm not able to convert data for year above 1999


Can someone suggest how to convert the dates in this format.

Regards,
Munish

[ray.wurlod]

See other post on this identical topic.