You can accomplish this by doing the following:
On the SQL tab of your view in design mode:
CONVERT(char(10), field) as newfield <----you can change the length to whatever is appropriate for your task, and field is the actual field you want to convert. You can name it anything you would like. I am using newfield for the example.
You can then nest this function within the SUBSTRING function.
Hope this helps!
Jackie D/Support Analyst