Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Borislav Borissov
 To: Kris Magnusson
  Where is Kris Magnusson?
 West Monroe
 Louisiana - United States
 Kris Magnusson
Subject: RE: DateTime Question
Thread ID: 154954 Message ID: 154957 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, December 20, 2007 7:13:15 PM         

> Hello,
> Is there a way to add two fields and get a datetime answer?
> Field 1 is a date. 12/20/07
> Field 2 is a char. 11:34am
> Thank you,
> Kris Magnusson

? DATETIME(YEAR(DateField), MONTH(DateField), DAY(DateField), VAL(LEFT(TimeField,2)), VAL(RIGHT(TimeField,2)))

Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.


DateTime Question Posted by Kris Magnusson @ 12/20/2007 7:04:30 PM
RE: DateTime Question Posted by Ken Murphy @ 12/20/2007 7:08:44 PM
RE: DateTime Question Posted by Borislav Borissov @ 12/20/2007 7:13:15 PM