Date conversion

snt_ds · Post by **snt_ds** » Tue May 29, 2007 7:47 am

I am having Date as "MMDDYY" format.
I have to convert this one as "YYMMDD" and also concatenate '20' to year.
Please send me the solution for this.

DSguru2B · Post by **DSguru2B** » Tue May 29, 2007 7:50 am

What have you tried so far? Did you look at StringToDate() function?

Maveric · Post by **Maveric** » Tue May 29, 2007 8:34 am

You need to concatenate 20 first and then use string to date function. Something like StringToDate(Col[1,4] : 20 : Col[5,2],"%mm%dd%yyyy).
Coll[1,4] gets u 4 characters from the 1st character. and Col[5,2] gets 2 characters from 5th characters. Not sure whether the count starts from 0 or 1. Try it out and let us know.

ray.wurlod · Post by **ray.wurlod** » Tue May 29, 2007 7:19 pm

No you don't. Just specify the 20 in the data format string. There are examples in the manuals and on-line help.