>Date and Time are stored in different columns of the array returned by ADIR() and they are different datatypes. Date last modified is Date and Time last modified is Character. How can I combine them into a DATETIME that can be inserted into a DATETIME field of a table?
Doug,
There're many ways to do that. Here's one
ldDate = DATE()
lcTime = TIME()
? DTOT(ldDate) + VAL(LEFT(lcTime,2)) * 60*60 + ;
VAL(SUBSTR(lcTime,4,2)) * 60 + VAL(RIGHT(lcTime,2))
--sb--