I want to convert the date format "20180618" to 6/18/2018, Can anybody help me out.

[TomCirone]

You can use the replace function to get rid of the asterisk (will probably need to use Chr in the replace).  If the special characters are causing it to break, just use a left and right to get the numbers. From there convert to a date, and use FormatDate([Date],""dd/MM/yyyy"")

[SudheerReddy]

Use the left, right & mid functions to extract date, month and year. Use makedate or format date to format the date with /