Extract single date from date range in same field

[eshie]

I have a field called Service Date which contains the following data example:

10/1/2010-11/1/2010

How do I extract each date into 2 separate fields (begin date/end date)?

Thanks!

[NeoPa]

In what environment?

In VBA you'd use the Split() function but in SQL or the design of an object you'd need to use Left() and Mid() in conjunction with InStr(). You need to make your question clearer to save wasting people's time.