Date in MMDDCCYY format

Raamc · Post by **Raamc** » Wed Oct 14, 2009 8:11 am

Hi All,

Can any one help me to conver the system date into DDMMCCYY format?

I coluld not find any equivalent VM-CONVERSION character in OCONV function.

chulett · Post by **chulett** » Wed Oct 14, 2009 8:41 am

Just convert it to day-month-year format and then strip your delimiter with something like Convert().

ray.wurlod · Post by **ray.wurlod** » Wed Oct 14, 2009 1:01 pm

Code: Select all

Oconv(Date(), "DDMY[2,2,4]" : @VM : "MCN")

chulett · Post by **chulett** » Wed Oct 14, 2009 1:47 pm

Or that, the equivalent of using the DIGITS transform.

Raamc · Post by **Raamc** » Thu Oct 15, 2009 3:22 pm

Thanks Ray,

It is perfectly working.