Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 28, 2017 at 08:17 AM

    You need to deconstruct and rebuild use this formula

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

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2017 at 10:03 AM

    Hi Jiten,

    Create a formula with this code:

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded