Fastest way to copy object

You can quickly create a copy of object as below,

1. Hold down the Ctrl key

2. Click and Drag the Object to copy

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.