Print Page | Close Window

Trailing Spaces

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19608
Printed Date: 04 May 2024 at 9:24pm


Topic: Trailing Spaces
Posted By: coountsr
Subject: Trailing Spaces
Date Posted: 04 Jun 2013 at 7:27am
trying to remove trailing spaces in a date range.
 
ex: 04/01/2013  02:28:37 , need it to look like this, 04/01/2013  02:28:37,
 
any suggestions?


Replies:
Posted By: bwsanders
Date Posted: 04 Jun 2013 at 7:34am
RTRIM({field}) should do the trick for you. 


Print Page | Close Window