https://community.blueprism.com/t5/Product-Forum/I-want-to-convert-the-date-format-quot-20180618-quot-to-6-18/m-p/51695#M6703 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"") Wed, 20 Jun 2018 01:21:00 GMT TomCirone 2018-06-20T01:21:00Z https://community.blueprism.com/t5/Product-Forum/I-want-to-convert-the-date-format-quot-20180618-quot-to-6-18/m-p/51694#M6702 Tue, 19 Jun 2018 23:07:00 GMT https://community.blueprism.com/t5/Product-Forum/I-want-to-convert-the-date-format-quot-20180618-quot-to-6-18/m-p/51694#M6702 dineshmentada 2018-06-19T23:07:00Z https://community.blueprism.com/t5/Product-Forum/I-want-to-convert-the-date-format-quot-20180618-quot-to-6-18/m-p/51695#M6703 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"") Wed, 20 Jun 2018 01:21:00 GMT https://community.blueprism.com/t5/Product-Forum/I-want-to-convert-the-date-format-quot-20180618-quot-to-6-18/m-p/51695#M6703 TomCirone 2018-06-20T01:21:00Z https://community.blueprism.com/t5/Product-Forum/I-want-to-convert-the-date-format-quot-20180618-quot-to-6-18/m-p/51696#M6704 Use the left, right & mid functions to extract date, month and year. Use makedate or format date to format the date with / Thu, 21 Jun 2018 19:41:00 GMT https://community.blueprism.com/t5/Product-Forum/I-want-to-convert-the-date-format-quot-20180618-quot-to-6-18/m-p/51696#M6704 SudheerReddy 2018-06-21T19:41:00Z