Exracting Dates

[Elizabeth]

Hello,
I am trying to extract seperate date values from a date-time group that looks like this:
200904021016
From this DTG I would like to make seperate columns for the year, month, day, and time. Im hoping there is a very easy way to do this as I have 100K+ records to edit that are formated exactly like the above.
If anyone can help I would be grateful and if you can keep it at a third-grade easy to understand level that would be great as well!



Thanks,
Elizabeth

[RuralGuy]

Does 200904021016 = Feb 4, 2009 10:16 AM?

[RuralGuy]

Or is it April 2, 2009 10:16 AM?