So imported 100k sales figures from Oracle for Oct and Nov but the day overran and month didn't change.
EX: 2012-10-32 instead of 2012-11-01. So I now have dates ranging from 2012-10-01 to 2012-10-59.
So trying to do date analysis is impossible.
How can I convert? any ideas?