Date Format

arshi · Post by **arshi** » Thu Jul 03, 2008 5:22 am

Hi,

I am facing following date conversion in my job:

Source data in the format: 26062008 (DDMMYYYY)
I required output as in oracle date format and that date is last day of that month.

I tried this :
Iconv(MONTH.LAST(Oconv(in_Trns_Check.XTRCT_DT , "D-DMY[2,2,4]")),"D-DMY[2,A3,4]") .But not working

Any one have the solution please provide.

Regards,
Arshi

chulett · Post by **chulett** » Thu Jul 03, 2008 7:15 am

First observation, you've got the Conv brothers backwards. IConv first, meaning innermost and then OConv second meaning outermost.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 03, 2008 4:08 pm

Moderator: please move to server forum