>>>As part of output which is redirected to a file, I have run into the following situation. The code
>>>
>>>? "message" + time()
>>>
>>>works fine and prints to the screen
>>>
>>>but the code
>>>
>>>? "message" + date()
>>>
>>>causes a type mismatch
>>>
>>>anyone know why?
>>
>>Hi Thomas,
>>
>>DATE() returns a date datatype and you're trying to display it as a string when you ? "message " + date(). You can use:
>>
>>? "message " + DTOC(DATE())
>>
>>or
>>
>>? " message " + TTOC(DATE()) && or DATETIME() as the parameter.
>
>Or you can use the trick you turned me on to yesterday:
>
>? "message "+TRANSFORM(DATE()) && (VFP6 only, of course)
Yep that'll work too, Fred. So will:
? "message", DATE()
The problem's caused by VFP attempted to concatenate the date data type into a single string (which, of course, I'm sure you know). Frankly, I didn't think of the above until after I had posted my response< g >.
George
Ubi caritas et amor, deus ibi est