Format a date field from within the formula

[Pistol]

I have two date/time fields that I am combining within one formula. Both fields contain both a date, and a time, and I need to combine them and format them.

Example
The database gives me this:
Field 1: 8/24/03 0:00
Field 2: 00/00/00 12:00
Field 3: 00/00/00 13:00

I need to format like the following:
"Appointment text 8/24/03 12:00-13:00"

Once I have combined the fields in the formula I cannot format the output. Here is my formula (without any formatting)

************************************************************
{BSACTIVITY_ttx.startdate} & " " & {BSACTIVITY_ttx.starttime} & "-" & {BSACTIVITY_ttx.enddate} & " " & {BSACTIVITY_ttx.enddate}
************************************************************

This data is coming out of SAP, and I cannot modify the database. Any modifications/formating has to take place in Crystal.

I know that if I put the fields on there individually I can format them the way that I want to, but then it doesn't look quite as nice.

Thanks for your help.
Peter McLernon

 

[Madawc]

For Crystal 8.5, use ToText and date formatting.

totext ({BSACTIVITY_ttx.startdate}, "d/M/yy&quot & " " &
totext ({BSACTIVITY_ttx.starttime}, "HH:mm&quot

etc.

Madawc Williams
East Anglia, Great Britain

 

[crystalreporting]

Or - merge all of the results into a text object, then format each field individually any way you want.

Peter Shirley

http://www.linkcorp.com

 

[Pistol]

Good stuff, thanks for the formula help