on 07-28-2017 7:31 AM
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}, '#/')
Hi Jiten,
Create a formula with this code:
Replace({your varchar field}, "/", "");
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You need to deconstruct and rebuild use this formula
right(yourfield, 4) & mid(yourfield, 4,2) ≤ft(yourfield, 2)
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.