04-20-2016 09:48 PM
I have a file that has dob dates coming in with char formats as 12/31/1977 and 1914-07-15. Same field different formats. How do i make them in the same format coming in as char in the end?
04-20-2016 10:18 PM
You shouldn't store as char because you can't do calculations on a char date variables, but try anydtdte as your informat. If you really want it as a char you can convert it.
04-21-2016 12:55 AM
04-21-2016 04:14 AM
I am with @LinusH here, the problem lies with your data supplier. You will of course have a data import agreement setup which defines the structure, content of the data yes? If not, then whatever you code may need to change next time you get data, I mean wht if the vendor decides to drop that field, or add a field, or change them all to DDMONYYYY? The control and specification is all in the documentation, programming is more or less irrelevant.