Page 1 of 1

Dta Formatting

Posted: Wed May 21, 2003 4:39 am
by shiva459
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

Posted: Wed May 21, 2003 5:28 am
by shiva459
Hi
I've found the way
Thanks
Shiv

Shivakumar

Posted: Wed May 21, 2003 6:21 pm
by ray.wurlod
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