Dta Formatting

shiva459 · Post by **shiva459** » Wed May 21, 2003 4:39 am

Hi
I have date in 2002-10-25 format and i want to have in MMMYYYY format
I am not able to use the Iconv and Oconv functions as they doesn't have the given format.Any help is appreciated.
[:)]

Shivakumar

shiva459 · Post by **shiva459** » Wed May 21, 2003 5:28 am

Hi
I've found the way
Thanks
Shiv

Shivakumar

ray.wurlod · Post by **ray.wurlod** » Wed May 21, 2003 6:21 pm

This CAN be done with Iconv and Oconv. For example:

Convert(" ","",Oconv(Iconv(TheDate, "DYMD"), "DMBY[A3,4]"))

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518