Skip to Content
0

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

Jul 28, 2017 at 06:31 AM

20

avatar image
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}, '#/')

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Jul 28, 2017 at 08:17 AM
0

You need to deconstruct and rebuild use this formula

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

Ian

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Jul 31, 2017 at 10:03 AM
0

Hi Jiten,

Create a formula with this code:

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded