Date Format

myukassign · Post by **myukassign** » Fri Aug 08, 2008 9:19 am

Can anybody help me with a function where I can generate the date in this format?

20080729

I have not find any option to get this using oconv iconv.

Please help

gabrielac · Post by **gabrielac** » Fri Aug 08, 2008 10:03 am

Try

Trim(Oconv(iconv( .... ), "DYMD[4,2,2]"), " ", "A")

Regards,
Gaby

chulett · Post by **chulett** » Fri Aug 08, 2008 10:07 am

That's certainly one variation. Basically, you need to generate the date in the proper YMD format with any delimiter and then strip the delimiter.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 08, 2008 4:13 pm

Code: Select all

DIGITS(Oconv(Iconv(....),"DYMD[4,2,2]"))

chulett · Post by **chulett** » Fri Aug 08, 2008 4:14 pm

That's certainly one variation.

myukassign · Post by **myukassign** » Mon Aug 11, 2008 12:48 am

Wht should i give inside iconv.?

Its not accepting @Date.

please help me

ray.wurlod · Post by **ray.wurlod** » Mon Aug 11, 2008 1:48 am

@DATE is already in internal format - so you don't need Iconv().

Code: Select all

Oconv(@DATE, "DYMD[4,2,2]":@VM:"MCN")

To pre-empt Craig, "that's certainly one variation".

chulett · Post by **chulett** » Mon Aug 11, 2008 6:51 am