>>The other responses gave sometimes complicated ways of doing it. I'm not sure why. All you you have to do is TTOC(Dtime1).
>>
>>-Michelle
>>
>>
>>>Help!
>>>
>>>I need to be able to display data from a DATETIME field as well as a CURRENCY field in a messagebox/ wait window and need to convert the data to a string.
>>>
>>>Is there any function to get the date and time as a string??
>>>
>>>eg the DATETIME field called Dtime1 has data 12/07/1999 14:23:44
>>>
>>>I need to display this the same way and need as a result a string as above "12/07/1999 14:23:44"
>>>
>>>How do I do this without extensive manipulation of hours(), minutes() etc??
>>>
>>>
>>>Bernard
>
>Michelle
>
>Thanks. Exactly my sentiments. Your answer is actually the one I discovered and used (no thanks to the vfp help system which misdirected me all over the place without giving me TTOC(). That I happened on chance.
>
>Thanks again
>
>Bernard

Glad you found it. I use it all the time. There's a lot of variations on that theme. TTOC, DTOC, DTOS, CTOD, CTOT... Probably more, but that's all I can think of.

-Michelle