I have a database that contains a 5 character field for 24 hour clock which is entered as hh:mm . I have a seperate date field in date format mm/dd/yyyy.

I would like to combine both of these into the foxpro datetime format.

Suggestions?