Can Crystal combine the Date and Time fields into one displayed field?

Version 1


    I have a crystal report and it needs to reflect the date and time as one item, but in the database these are two separate fields; RecvdDate and RecvdTime.  I would like it to reflect in the report in a single field format like "8/11/14 11:35 AM".


    This combination is possible using HFWDateToDate and CTime functions in a DateTime crystal function format.  Create the following Formula Field to add to the report:

    DateTime (HFWDateToDate ({CallLog.RecvdDate}),CTime ({CallLog.RecvdTime}))