Iconv & Oconv logic

kamaldeep.kaur · Post by **kamaldeep.kaur** » Thu Jul 07, 2011 12:55 am

Hi all,

I am using Oconv function to convert @DATE to YYYY/MM/DD format.
As @DATE output is 15894 which is today's date "07/07/2011".

But when i apply Oconv(@DAY,"D/YMD[4,2,2]") its gives output as "1968/01/07".

Please suggest how these Iconv and Oconv functions works and how i got the above error

Thanks
Kamal

ray.wurlod · Post by **ray.wurlod** » Thu Jul 07, 2011 2:26 am

@DAY is the day of the month. It only has values between 1 and 31. So applying that Oconv() function to it could only yield values in the range "1968-01-01" through "1968-01-31". Clearly you executed it on the seventh of the month.

To put it another way, @DAY and @DATE are not the same thing.

kamaldeep.kaur · Post by **kamaldeep.kaur** » Mon Jul 11, 2011 11:26 pm

sorry it was typo i used @DATE instead of @DAY
Oconv(@DATE,"D/YMD[4,2,2]")

still i get "1968-01-07"??

Kamal

vasubabu · Post by **vasubabu** » Tue Jul 12, 2011 12:48 am

Try this

Oconv(iconv(@DATE,"D/E") ,"D/YMD[4,2,2]")

hemanthakumar · Post by **hemanthakumar** » Wed Jul 13, 2011 2:41 am

Hi Kamal,
The below code is working fine, it gives the correct output "2011/07/13"

Code: Select all

Oconv(@DATE,"D/YMD[4,2,2]")

.

chulett · Post by **chulett** » Wed Jul 13, 2011 6:34 am

Yah, there was nothing wrong with the OConv you posted. If you still have the issue, show us exactly how/where you are using it, something else is causing the issue.

PhilHibbs · Post by **PhilHibbs** » Wed Jul 13, 2011 9:23 am

kamaldeep.kaur wrote:still i get "1968-01-07"??

So, 5 days later you still get the same result? Can't be the server clock set wrong then, I guess.