Date Time Help

[doubley]

I have a two fields one called Date and another called time. I would liked to combine these fields and then create another field that would just reflect the time. Here is and ex.

Field-DATE - 8/20/1967 Field - TIME-11:50

I would like to do this:


Field-DATE-11/20/1967 115025 Field-TIME - 11:50

Can someone tell me how can I do this. Again I just want to combine the date and time field then create a field that will only reflect the time. But the time must be the same as what was combined. If you need further clarification feel free to just ask.

[Rawhide]

Use the concatenation operator ( + ) to combine the two fields into 1.