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
Julian Date Convert
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: