Hi Joe,
You will probably need to parse your values (year, month, day, hour, etc.) then use the DATETIME() function
DATETIME([nYear, nMonth, nDay [, nHours [, nMinutes [, nSeconds]]]])
to create your datetime variable. See DATETIME() in the Help.
Bill
>Hi there,
>
>I'm working on an application written in VFP 7.0.
>
>I have a class object form for user input, in which the fields can be set up (at runtime) to accept Date, time, char, or logical data, depending on what my app specifies when the user input form is created using CREATEOBJECT. It's working fine. My problem is that I'm returning a date from one field and a time from another one. The date's type is Date and the time's type is Char. I need to use those values to query data in my FoxPro database, and would like to easily concatenate the date and time to make a valid datetime to use in my query.
>
>Any ideas on a quick way to do this?
>
>Thanks!
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.