Text date conversion to formatted date

In this post, we will learn how to convert "text" date, for example 28.10.2008 to a formatted date i.e 28-Oct-2008. The steps are as follow;

1. Use Mid function to split text to three category i.e day, month & year
2. Using Date funtion to convert the value to formatted date.