Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Date field and Time field into DateTime Field?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00612879
Message ID:
00612883
Views:
21
This message has been marked as the solution to the initial question of the thread.
Hi Steve.

You should be able to issue a CTOT(DTOC(ldDate) + SPACE(1) + ltTime) where ldDate is a valid date (not empty too) and ltTime is a valid time.

Doug
>I wrote a conversion program to convert fields from one table into another table.
>
>I want to convert the Date field (Date 8) and the Time field (Char 8) as in HH:MM:SS into a Datetime field (DateTime 8). Is there an easy way to do this?
>Some values in the time field are military time such as 21:30:45. Do I have to worry about SET HOURS to do this?
>
>Thanks very much. I will be working on it too. I guess I would use CTOT() in combination with some other functions.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform