how to display the varchar field data 26/06/2017 without slash in formula field of Crystal Report

[Former Member]

database field Varchar , data is 26/06/2017

need to fetch the data in crystal report without backward slash, end data that need to be reflected in report should be 26062017.

I am using below ToText ({Tablename.ColumnName}, '#/')

[abhilash_kumar]

Hi Jiten,

Create a formula with this code:

Replace({your varchar field}, "/", "");

-Abhilash

[Former Member]

You need to deconstruct and rebuild use this formula

right(yourfield, 4) & mid(yourfield, 4,2) ≤ft(yourfield, 2)

Ian