12-09-2015 12:30 PM
I've a raw file with different date values in different records.
How to read different date types from raw file.
12-09-2015 12:43 PM
12-09-2015 01:34 PM
Don't be surprised if you get values you don't expect.
Your example of 12112014 will depend on your national language setting for whether that is supposed to be MM/DD/YY or DD/MM/YY.
And 201113 is likely to have problems if it is supposed to be YYYYMMDD as it could be interpreted as 2011 Jan 3 or 20 Nov 2013
12-09-2015 01:40 PM
12-10-2015 04:59 AM
Personally I wouldn't risk trying to work with that data. Go back to your data import agreement - you have on of those right? - and check what it states in there. If you dont have one of those, make one and get the vendor to agree to it. They should be providing a robust, structured dataset, which they currently are not. For instance, what does 12112014, mean? Is it december or november. As with everything programmatic - specify, specify, specify, then code. Programming is in fact 99% irrelevant, specification and documentation is the key.