Crystal Reports combine a separate Date and time field into 1 field

If you have a situation where you have your date and time stored in 2 separate DB fields. You may wish to combine these, either for display, formatting or sort purposes.

To do so, you simply use the following code.

Where Field1, is your date field and Field2 is your Time Field

 

datetime(Field1,Field2)