general question here guys, I get a report that is in CSV form on a weekly
basis that inludes dates. Some of the data has the date format reversed.
i.e. 02/01 instead of 01/02.

I am ok with the logic of sorting this issue BUT, sometimes the data
transforms into a number. i.e. 49025. why should this be? how can I convert
it back to a "real" date.?

TIA any ideas