How do I combine a MULTIPLE DATE Field with a TIME Field to form a DateTime field in Crystal Reports XI?
My date field is broken up into year, month, day. The data is the year field is 7 for 2007, 8 for 2008. The day is 1,2,3,etc. The month is 1,2,3,etc. Then I have a time field which is military time, in another field. I need to be able to subtract DISCHARGE DATE (3 fields) and DISCHARGE TIME (1 military time field) from ADMIT DATE and ADMIT TIME (same format).
I can do this in Crystal or Excel, I just need it! Can anyone help!????