>
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?>
>datetime_val = CTOT(DTOC(date_field)+ " " + timefield)
Trey,
The only problem with this is that it may produce incorrect results. If for example the current setting has CENTURY set to OFF, rollover is the default value, and the date_field equals July 27, 1900, the code about will return a date for 2000.
George
Ubi caritas et amor, deus ibi est