General information
Category:
Coding, syntax & commands
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only