Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Left-align times?

Status
Not open for further replies.

DavidMarcus

Technical User
Feb 2, 2002
8
US
When a time field in the format is left-aligned, it looks like Crystal is leaving a space to the left of times that have single digit hours. This is driving me crazy - is there a solution to it?

It also happens when I embed time fields into text objects. I am using Crystal Reports 8.0 and using RDC to embed them in our applications.

David Marcus
GMT Corporation
 
try this formula

totext({table.time},'h:mm')

Hope this helps
Jim
 
Ngolem,

Is there any way to apply this format to a time field itself? It seems like a should-be-unnecessary step to have to create a formula just for display purposes - not that it would be the first time I've done that.

Thanks, I am using Crystal Reports 8.0 and using RDC to embed them in our applications.

David Marcus
GMT Corporation
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top