How can I split Date column values in Access into 2 columns? I have a date column that stores values for begining to end date as:
070314-073114
So I need to split it to 2 columns that has the Start Date as 070314 and End Date as 073114, any suggestions?

This database is still in Microsoft Access, and eventually after cleaning it up, we will move it to SQL Server.

Thanks in advance
ALTER TABLE table ADD COLUMN Start_Date TEXT(6)
ALTER TABLE table ADD COLUMN End_Date TEXT(6)

update table
set Start_Date = Left(column,6),
End_Date = Right(column,6)