how to display the varchar field data 26/06/2017 without slash in formula field of Crystal Report -
database field varchar , data 26/06/2017
need fetch data in crystal report without backward slash, end data need reflected in report should 26062017.
i using below totext ({tablename.columnname}, '#/'). don't know wrong, pls help.
if text field can use replace function
replace({tablename.columnname},"/","")
but if have datetime field can right click fiels , select format field on date , time tab select customize , date tab, in separators box select first , second formula editor button , write "" in formula. ddmmyyyy format
Comments
Post a Comment