>>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??
>
>DTOC(
DateTime), DMY(
DateTime) or MDY(
DateTime) can extract the date as a character expression in several formats, while TTOC(
DateTime,2) will extract the time as a character expression. You can put them together to make what you need.
>
>Currency data is best converted to strings using the TRANSFORM() function.
>
>>
>>eg the DATETIME field called Dtime1 has data 12/07/1999 14:23:44
>>
>
>With SET CENTURY ON,
DTOC(Dtime1) + ' ' + TTOC(Dtime1,2) does what you want.
>>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
You can use TRANSFORM on DATETIME type variables also:
cDT = TRANSFORM(DATETIME(),'')