>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?
Sure:
tdatetime = DATETIME(YEAR(ddate), MONTH(ddate), DAY(ddate), VAL(LEFT(ctime, 2)), VAL(RIGHT(ctime, 2)))
Of course, this is VFP 6.0.
George
Ubi caritas et amor, deus ibi est