Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datetime
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00397324
Message ID:
00397327
Views:
10
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform