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.
Date conversion
Moderators: chulett, rschirm, roy
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: