>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
Bernard,
For DateTime use DTOC(TTOD(DateTime)) + " " + TTOC(DateTime,2),
for currency use STR()