Format Date/Time to Two Lines 1

[ddnh]

I have a date/time field that I need to format so the date is on one line and the time is on the line below. with most fields I can do this by adjusting the field width/heighth...the text wraps. For some reason, the date time field does not wrap.

One solution I have is to insert the field twice, one beneath the other. then format accordingly. I'm just wondering if there is a way I can do it without inserting the field twice. Or is the performance issue with the field inserted twice going to negligible?

field contents: 6/1/2003 2:21:05 PM
I want it to look like:

6/1/2003
2:21:05 PM

 

[synapsevampire]

Performance decrease should be negligible.

You could also create a formula which displays them both, as in:

totext({datetimefield},"M/d/yyyy&quot+chr(13)+totext({datetimefield},"H:mm:ss&quot

-k

 

[Reebo99]

I'd put the field on the report twice, then right click each field and format.

You can make one field display the date only and the other field display the time only.


Reebo
Scotland (Sunny with a Smile)

 

[kenhamady]

If you could actually benchmark this, I think the BEST performance will be to add the field twice. The field is already in the result set so the database doesn't do any more work. Even a formula would take some small amount of processing. But, I would bet that you won't notice a difference using any of the above techniques.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com