Page 1 of 1

Need to convert dd-mm-yy to yyyymmdd format

Posted: Mon Aug 29, 2011 3:39 am
by mac4rfree85
Hi Guys,

I am getting a string in the format dd-mm-yy which i want it to convert it to yyyymmdd format. Can somebody help me.

Code: Select all

I/P                             O/P
21-01-86             19860121
23-03-08              20080323
Cheers!!!!

Posted: Mon Aug 29, 2011 4:47 am
by ray.wurlod

Code: Select all

Oconv(Iconv(InLink.TheDate, "DDMY"), "DYMD" : @VM : "MCN")