Julian Date to YYYYMMDD
Posted: Tue Nov 23, 2004 2:54 pm
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]")
But I've dates coming in format 104314 i.e. 2004-11-09 for which above routine do not works.
Can someone suggest how to convert the dates in this format.
Regards,
Munish
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]")
But I've dates coming in format 104314 i.e. 2004-11-09 for which above routine do not works.
Can someone suggest how to convert the dates in this format.
Regards,
Munish